6 Replies Latest reply: Nov 17, 2017 10:36 AM by Pierre Chazel

# Ignore filter selection + force on another value

Good morning,

I´ve tried to find the answer on previous posts, but I didn´t, I apologize if this question was already asked before.

Here is my question if I sum it up :

- I have in my table Volumes, per Year ("2016", "2017", "Budget 2018" ).

- I have a Filter pane based on Year, so they can select any year, and I want to show 2 Objects,

1- a KPI Object with the volume of the selected year (they will choose "2017", or "Budget 2018"), which is easy, directly linked to the filter

2- a KPI Object with the volume of 2016. The issue being that I need to force the formula to ignore what the user selected, and at the same time force the volume to be linked with 2016...

Is there a solution with the Set Analysis - trick to make it work, given I worked in Sense Cloud ?

Thanks a lot, I tried to be as clear I as could...

Have a good day,

Pierre

• ###### Re: Ignore filter selection + force on another value

Hi Pierre,

Did you try set analysis?

Look to the attach.

Have nice day,

Petr

• ###### Re: Ignore filter selection + force on another value

Maybe sum({<Year={'2016'}>}Volume)

• ###### Re: Ignore filter selection + force on another value

Hi Petr,

I asume there is a solution in Set Analysis, but I haven´t found it yet.

Your solution unfortenately wouldn´t work because the user will select 2017 or Budget 2018, and as consequence sum({<Year={'2016'}>}Volume) would be = 0...

Pierre

• ###### Re: Ignore filter selection + force on another value

Is there a way we could get a test data set?  What about

Sum({1<Year={'2016'}>}Volume)

The 1 would tell your Qlik that you want to survey the WHOLE set, and not just what is in the allowable data set based on user selections(\$)...I think..

• ###### Re: Ignore filter selection + force on another value

You can try to generate an auxiliary table in the data load script with the data of 2016 and put them in the second KPI. It is not tested but it may work.

Maybe that works.

Regards

• ###### Re: Ignore filter selection + force on another value

Sorry to answer a little late, after many try&error, I did find a solution, a simple {<[Marché.Cycle]={'R2016'},[Marché.Pays]={'ESPAGNE'}>} worked :-)