Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Pierre,
Did you try set analysis?
Look to the attach.
Have nice day,
Petr
Maybe sum({<Year={'2016'}>}Volume)
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
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
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..
Sorry to answer a little late, after many try&error, I did find a solution, a simple {<[Marché.Cycle]={'R2016'},[Marché.Pays]={'ESPAGNE'}>} worked 🙂