How to exclude columns in a Pivot Table in Qlik Sense

[Anonymous]

Hello,

I am trying to view my financials by year but I want to exclude the two bottoms ends. I do not want to see 2015 and 2020, which are at the ends of what I am trying to view. Is there a way to limit the display of the table's columns to 2016-2019.

Thanks,

[sunny_talwar]

May be use set analysis to exclude them..

{<Year -= {2015, 2020}>}

[Anonymous]

I type that in the {<Year -= {2015, 2020}>} into the expression editor and receive an error of "garbage after "-="

What do you think?

[silvacarlos]

Maybe {<Year =- {2015, 2020}>} ?

[Anonymous]

Unfortunately we get the same error here

[sunny_talwar]

Can you show an image?

[Anonymous]

[Anonymous]

{<Year <> {2015, 2020}>}  Try that ?

[sunny_talwar]

Where did the expression go?? Did you use this as a dimension?

[Anonymous]

that expression is going into limitation -> exact value -> expression box