Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble with a KPI using set analysis. I am showing totals by regions NA and EU:
='NA: '&num(sum({$<Region={'North America'}>}[Positions Remaining]),'#,##0')&' EU: '& sum({$<Region={'Europe'}>}[Positions Remaining])
It works and changes accordingly based on various filters selected. But, if I filter on a Region, it does not change. For example, with no filters selected, I get, 'NA: 140 EU: 80'. If I select any filter, I get, say 'NA: 75 EU: 20'. But, if I select a region (e.g. NA), it still shows 'NA:75 EU:20' when I want it to show 'NA:75 EU:0' since only the NA should show up.
Hi @cander19 ,
I guess it works as expected.
Let's try this expression:
='NA: '&num(sum({$<Region*={'North America'}>}[Positions Remaining]),'#,##0')&' EU: '& sum({$<Region*={'Europe'}>}[Positions Remaining])
I hope it can help.
Best Regards
Hi @cander19 ,
I guess it works as expected.
Let's try this expression:
='NA: '&num(sum({$<Region*={'North America'}>}[Positions Remaining]),'#,##0')&' EU: '& sum({$<Region*={'Europe'}>}[Positions Remaining])
I hope it can help.
Best Regards
The solution, using an implicit set operator, provided by @cander19 should help you.
Read about implicit set operators in this Qlik Help page: Set modifiers using assignments with implicit set operators
Outstanding! Thank you very much.