Count based on (count) condition.

[dpmbrouwers]

To all Qlik friends and wizards,

Any help with below issue is really appreciated.

From my data, I would to like to extract the following information:

Per date, whenever the Value “Test_Verrichtingen” has a value, I want to know the number of instances in which the “Specialisme” has more than 1 distinct value.

In this example (with only one date), that would be 1 as only value 68 “Test_Verrichtingen” has multiple distinct values.

[lironbaram · Accepted solution]

hi 

something like 

sum(aggr(if(count(distinct  Specialisme)>1,1,0),Test_Verrichtingen,Date))

[dpmbrouwers]

Hi Lironbaram,

Not exactly, but it pointed me in the right direction. I forgot to mention that I already have a table with the dates, so the following solution fitted my needs:

Sum(aggr(if(count(distinct Specialisme)>1,1,0),Test_Verrichtingen))

Thanks for your help!