Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

subrato312
New Contributor II

keep all columns in pivot table even after filter is applied in another sheet

I have two sheets. In sheet2 I have a pivot table with columns as 'year' (2015 to 2018), so when I apply a filter '2018' in sheet1 and then when I move to sheet2  only 2018  column is visible. I want to keep all four columns in sheet2. 

year is calculated from field 'Order Date' as [Order Date.autoCalendar.Year]

Please help me in ignoring filter in pivot table in sheet2.

Thanks for your help

1 Solution

Accepted Solutions
Partner
Partner

Re: keep all columns in pivot table even after filter is applied in another sheet

Hi,

you can bypass the Year in the measure. 

ex: sum({<[Order Date.autoCalendar.Year]>}[Order Total])

3 Replies
Partner
Partner

Re: keep all columns in pivot table even after filter is applied in another sheet

Hi,

you can bypass the Year in the measure. 

ex: sum({<[Order Date.autoCalendar.Year]>}[Order Total])

MVP
MVP

Re: keep all columns in pivot table even after filter is applied in another sheet

Add a set expression selection override into your expression. Something like

Sum({<[Order Date.autoCalendar.Year]>} Amount)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
subrato312
New Contributor II

Re: keep all columns in pivot table even after filter is applied in another sheet

This works well but in cases where there is no value for any year then only three columns are visible. Is there any way to keep all columns in case there is no value for a certain year?