Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Item | Value |
---|---|
A | 100 |
B | 200 |
C | 300 |
D | 400 |
E | 500 |
Above is a pivot table in QlikSense. Could you please advise the formula to be put in in order to show only Item B and E?
You can do this via Set Analysis or with calculated dimensions.
With set analysis would be something like this:
With calculated dimension it would be something like this:
I prefer using set analysis over calculated dimensions for better performance with big data sets.
Please let me know if this helps.
Kind regards,