Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
New to QLIK and love it so far...this is prob an easy question.
I have 3 dimensions (SCENARIO, VERSION and CATEGORY)
For the 'SC.Actual' SCENARIO, I need the VERSION to be fixed with 'VR.Final', however i want the CATEGORY to be flexible depending on what the user selects on the Filter Pane Chart.
Here is my set analysis expression:
Sum({1<SCENARIO_ANCESTOR_ID={'SC.Actual'},VERSION_ID={'VR.Final'}>}AMOUNT)
this stays the same number no matter what category is chosen on the filter pane chart. is it possible for some dimensions to be set and some to be dynamic?
Thanks!
Try like:
If( SCENARIO_ANCESTOR_ID='SC.Actual', Sum({<VERSION_ID={'VR.Final'}>}AMOUNT) , Sum(AMOUNT) )
Thanks so much for quick feedback!
I need the Version to stay "VR.Final" even if the VERSION is change on the filter pane chart. It's a transpose extensions and here is the complete code that i am using:
IF(ValueList('Actual','CV','OL')='Actual',
Sum({1<MEASURE_ANCESTOR_ID={'AC.IS40'},SCENARIO_ANCESTOR_ID={'SC.Actual'},VERSION_ID={'VR.Final'}>}AMOUNT)
,
IF(ValueList('Actual','CV','OL')='CV',
Sum({<LAYER_DESC_LVL_2={'Total Layer'},MEASURE_ANCESTOR_ID={'AC.IS40'},SCENARIO_DESCRIPTION={'Budget'}>}AMOUNT)
,
IF(ValueList('Actual','CV','OL')='OL',
Sum({<LAYER_DESC_LVL_2={'Total Layer'},MEASURE_ANCESTOR_ID={'AC.IS40'},SCENARIO_DESCRIPTION={'Outlook'}>}AMOUNT)
)))
Sorry did I just complicate it? usually i get a response pretty quickly...
Believe the following Design Blog post should get you on the right track with things:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Regards,
Brett