Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alliedarmour
Contributor III
Contributor III

Set Expression Filter not working

Hi! 

I'm new to Qlik Sense for my new work and trying to understand why my filter critera in my set expression is not working.

Im filtering records based on a certain catalogue which should be always selected including the current selection and two aggregated values.

This is my set expression:

Count ({$<Leistungskatalog={'EBM2000+'}, FallBewegungKey = {"=Aggr(Count(ICD), FallBewegungKey) > 0"}> + <FallBewegungKey = {"=Aggr(Count(Leistungsziffer), FallBewegungKey) > 0"}>} DISTINCT Fallnummer)

The important thing is the first part where the record set should be filtered on the EBM2000+ catalogue. The correct count which should appear is 290, which indeed is correct when I manually select the filter option:

qlik1.PNG

 

But when I clear the filter option on the catalogue, the filter doesn't seem to be applied by the set expression and the other catalogues are shown aswell:

qlik2.PNG

Where am I wrong here? Thanks for any help!

 

Labels (4)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

Unable to grasp much but I think your set expression should just be
Count ({$<Leistungskatalog={'EBM2000+'}, FallBewegungKey = {"=Aggr(Count(ICD), FallBewegungKey) > 0"}>} DISTINCT Fallnummer)
,
Because in second part of set analysis you didnt define that  :-
Leistungskatalog={'EBM2000+'}

View solution in original post

1 Reply
Gabbar
Specialist
Specialist

Unable to grasp much but I think your set expression should just be
Count ({$<Leistungskatalog={'EBM2000+'}, FallBewegungKey = {"=Aggr(Count(ICD), FallBewegungKey) > 0"}>} DISTINCT Fallnummer)
,
Because in second part of set analysis you didnt define that  :-
Leistungskatalog={'EBM2000+'}