Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try using this:
Count({ $<OrderWeek *={'38'}>} OrderId)
You can read about the use of * here: Implicit Set Operators
Try using this:
Count({ $<OrderWeek *={'38'}>} OrderId)
You can read about the use of * here: Implicit Set Operators
Thanks Sunny T for the quick answer as always!