Announcements
cancel
Showing results for
Did you mean:
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)

• ### Distinct values

1 Solution

Accepted Solutions
Partner - Master III

hi

something like

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

2 Replies
Partner - Master III

hi

something like

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

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))