Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
flygstolen_fred
Not applicable

Set expression and filtering

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?

OrderIdOrderWeekTotal
54637299
54737549
68938499
69038495
69138399

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

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

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Set expression and filtering

Try using this:

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

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

2 Replies
sunny_talwar
Not applicable

Re: Set expression and filtering

Try using this:

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

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

flygstolen_fred
Not applicable

Re: Set expression and filtering

Thanks Sunny T for the quick answer as always!