Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Bhargavgs
Contributor
Contributor

Count based on a count condition - expression

 
 
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.

Labels (3)
1 Reply
vinieme12
Champion III
Champion III

Dimension

=Order_Number

MEasure

=count({<Order_Number={"=count(Order_Number)=1"}>}Order_Number)

 

Refer this article

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.