Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

Yes, Year is the dimension

Anonymous
Not applicable
Author

no luck here either

Anonymous
Not applicable
Author

I just tried it in the pivot table dimension area as well and it does not work

sunny_talwar

When I say expression... I mean measure

Anonymous
Not applicable
Author

so we have a pivot table with years displayed as the columns and lots of measures populating the rows. All we want to do is not display the first and last year columns somehow.

shivanandk
Partner - Creator II
Partner - Creator II

Sum( {Year =- {2015,2020} >} Revenue) 

This should work.  Replace Revenue with your metric field that you are using.

Anonymous
Not applicable
Author

MATCH(if(Year <> 2015 or Year <>2020))