Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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:
Where am I wrong here? Thanks for any help!
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+'}
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+'}