New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this topic

DutchArjo
Creator
Creator

difference in meaning in (set) expressions

For a Qlik sense training course I have created a gauge displaying the ratio of males as a percentage of the total population. Because I wanted to have a benchmark, I set a limit which is dynamic with the use of a set-expression.

Whenever I select a different age group, the gauge changes to display a new number.

I have created a master item (measure) for this ratio and added this expression:

 

count(distinct(if(Gender='Male',PatientID)))
/
count(distinct(PatientID))


 

I don't know why but I thought of finding out a different way to write this expression. I tried some things and finally ended up with this:

 

count({1<Gender={'Male'}>} distinct(PatientID))
/
count(distinct(PatientID)) 

 

Can I conclude that both expressions actually do the same and performance-wise: does one way have an advantage over the other?

Labels (3)
Who Me Too'd this topic