Set expression and filtering

[flygstolen_fred]

Hi,

When I apply a filter to show number of order for a certain week some KPI outside the selection are still visible and not blanked out. Is this by design in Qlik Sense or am I doing something wrong?

OrderId	OrderWeek	Total
546	37	299
547	37	549
689	38	499
690	38	495
691	38	399

If I apply a filter to only show OrderWeek = 37 then the set expression:

COUNT({ $<OrderWeek={'38'}>} OrderId) doesn't get blanked out.

[sunny_talwar · Accepted solution]

Try using this:

Count({ $<OrderWeek *={'38'}>} OrderId)

You can read about the use of * here: Implicit Set Operators

[flygstolen_fred]

Thanks Sunny T for the quick answer as always!