Apply filter in pivot tables

sguerra2 — Tue, 09 Mar 2021 16:47:28 GMT

Hi Community,

I have a pivot table that has as columns Year month- I just need 2021 info to be visible.. I tried with a set analysis to the measure, the information seems to be filtered but not removing the colums that belong to 2020 data-- i am not able to filter JUST info and columns just for year months that belong to 2021 info..any suggestions?

Thanks a lot!

@fmonetti

Sofía

Re: Apply filter in pivot tables

MayilVahanan — Wed, 10 Mar 2021 01:12:42 GMT

Hi @sguerra2

Try like this

Sum({<Year={2021}>}yourexpression)

For dynamic,

Sum({<Year={$(=Max(Year))}>}yourexpression)

And suppress the zero values.

topic Re: Apply filter in pivot tables in QlikView

Apply filter in pivot tables

Re: Apply filter in pivot tables