topic Re: Display only certain value in dimension in straight table/pivot tale in QlikView

Display only certain value in dimension in straight table/pivot tale

Amelia_96 — Mon, 01 Feb 2021 13:57:26 GMT

Hi, i have another problem where in one dimension, let say status got 5 values which is Paid, Pending, Inforce, Cancelled and Terminated. But i just want to show Paid and Pending in the pivot table. How do i do this ya? Because when i select status as dimension, it will show all five status.

Please help me. Thank you!!

Re: Display only certain value in dimension in straight table/pivot tale

GaryGiles — Mon, 01 Feb 2021 14:22:56 GMT

If you wanted to limited the values by only using the dimension field, you could use:

aggr(Only({$<Status={'Paid','Pending'}>} Status),Status)

Or, if you have a measure, just add {$<Status={'Paid','Pending'}>} as set analysis.

Re: Display only certain value in dimension in straight table/pivot tale

Amelia_96 — Tue, 02 Feb 2021 03:15:37 GMT

It works! Thank you 🙂