Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dpmbrouwers
Contributor III
Contributor III

Count based on (count) condition.

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.

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

something like 

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

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

something like 

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

dpmbrouwers
Contributor III
Contributor III
Author

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!