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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Two formulas comparison

Hi guys,

I'm new to Qlik Sense. What is the difference between:

COUNT(IF(value=20,value))

and

COUNT({<value={"20"}>}value))?


Thanks for help!

1 Reply
h_prakash
Creator II
Creator II

COUNT(IF(value=20,value))


In this it wont create a subset where value = 20 so in the above expression it will count null values.


COUNT({<value={"20"}>}value))

It will create a exact subset and it will count where that condition satisfies.


Hope this helps