Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lemon_lyman
New Contributor II

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

Tags (1)
6 Replies
gladi-cz
Contributor

Re: Ignore filter selection + force on another value

Hi Pierre,

Did you try set analysis?

Look to the attach.

Have nice day,

Petr

OmarBenSalem
Esteemed Contributor

Re: Ignore filter selection + force on another value

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

mikelmuru
New Contributor II

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

lemon_lyman
New Contributor II

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

JustinDallas
Valued Contributor II

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..

lemon_lyman
New Contributor II

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 :-)

Community Browser