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
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Who Me Too'd this topic

DutchArjo
Contributor III
Contributor III

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