Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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