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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.