topic Re: Filter a pivot table based on the calculated % in QlikView

Filter a pivot table based on the calculated %

antodina — Fri, 27 Jul 2018 07:23:52 GMT

Hello everyone, I would need to filter a pivot table based on the calculated% result in the table. The result I would like to obtain is to display only the records for which the calculated field of the discount percentage is greater than 60%. Thanks in advance to those who can help me. Antonio

Re: Filter a pivot table based on the calculated %

ogautier62 — Fri, 27 Jul 2018 07:32:10 GMT

Hi,

you need aggr with something like that :

if(aggr( your calcul of discount percentage,Item) > 60,Item)

with not display null values

regards

Re: Filter a pivot table based on the calculated %

antodina — Fri, 27 Jul 2018 08:00:57 GMT

thanks

best regards