QlikView-基于计数条件的计数
我有下表。
| order_number |
|---|
| 100 |
| 101 |
| 101 |
| 102 |
| 103 |
| 103 |
| 103 |
| 104 |
| 104 |
我想创建一个表达式，该表达式计算order_number仅发生一次的实例。 示例-100和102不重复，而101、103和104具有多个实例。 预期的结果是2。
我尝试了 count（{＆lt; count（order_number）= {1}＆gt;} order_number） 但似乎不起作用。
也尝试使用AGGR count（（（{＆lt; aggr）（count（order_number），order_number））= {1}＆gt;} order_number）
I have the following table.
| order_number |
|---|
| 100 |
| 101 |
| 101 |
| 102 |
| 103 |
| 103 |
| 103 |
| 104 |
| 104 |
I'd like to create an expression which counts instances where order_number occurs only once.
Example - 100 and 102 do not repeat, while 101, 103 and 104 have multiple instances.
The expected result is 2.
I've tried
count({<count(order_number)={1}>}order_number)
but does not seem to work.
Tried using Aggr too
count(({<Aggr(count(order_number), order_number))={1}>}order_number)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
（可能不是很有效的方法）
sum（if（aggr（count（order_number），order_number），order_number）= 1、1、0））（从内部到外）
aggr（count（count_number）） ，order_number）- willcount每个order_number的实例order_number如果内部（count）计算等于1，则返回1else 0 0sum（...）所有这些和结果（在文本框中）
如果可能的话（取决于您的要求）在脚本中标记这些记录。之后，表达式将非常简单（有效）
(Probably not very efficient way)
sum( if( aggr( count( order_number ), order_number) = 1, 1, 0 ) )(from inside to outside)
aggr( count( order_number ), order_number)- willcountthe instances of eachorder_numberif( ... = 1, 1, 0)- for eachorder_numberif the inner (count) calculation is equal to 1 then return1else0sum(...)all of thisAnd the result (in the textbox)
If possible (depends on your requirement) flag these records in the script. After that the expression will be much simple (and efficient)