Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rglenn0780
Contributor

How to exclude columns in a Pivot Table in Qlik Sense

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,

16 Replies
MVP
MVP

Re: How to exclude columns in a Pivot Table in Qlik Sense

May be use set analysis to exclude them..

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

rglenn0780
Contributor

Re: How to exclude columns in a Pivot Table in Qlik Sense

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

What do you think?

silvacarlos
Contributor II

Re: How to exclude columns in a Pivot Table in Qlik Sense

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

rglenn0780
Contributor

Re: How to exclude columns in a Pivot Table in Qlik Sense

Unfortunately we get the same error here

MVP
MVP

Re: How to exclude columns in a Pivot Table in Qlik Sense

Can you show an image?

rglenn0780
Contributor

Re: How to exclude columns in a Pivot Table in Qlik Sense

kellymcgrady
Contributor

Re: How to exclude columns in a Pivot Table in Qlik Sense

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

MVP
MVP

Re: How to exclude columns in a Pivot Table in Qlik Sense

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

rglenn0780
Contributor

Re: How to exclude columns in a Pivot Table in Qlik Sense

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