Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?