topic Choose columns to sum - pivot table in QlikView

Choose columns to sum - pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a base year for each process, that it is diferent each time, and I need to sum, all years that are not base.

For this, I have an expression:

if(

SecondaryDimensionality()=1,

bla bla bla ,

SUM(

Aggr(

( Sum({$< VARIABLE={'BUDG_PROVISIONS'}, SCENARIO_MOODYS={'PROVISIONS_ICAAP_2015','Final_Results_ICAAP_2015'}, SCENARIO={B}, VARIABLE_YEAR=VARIABLE_YEAR -{"$(=Max(BASE_YEAR))"} >} VARIABLE_VALUE))

, VARIABLE_YEAR,VARIABLE_SEGMENT,PROCESS)

)

)

Thanks!

Re: Choose columns to sum - pivot table

swuehl — Thu, 02 Feb 2017 19:58:32 GMT

Set Analysis does not consider your dimension values.

Maybe use something like

if(

SecondaryDimensionality()=1,

bla bla bla ,

SUM(

Aggr(

( Sum({$< VARIABLE={'BUDG_PROVISIONS'}, SCENARIO_MOODYS={'PROVISIONS_ICAAP_2015','Final_Results_ICAAP_2015'}, SCENARIO={B} >}

If(VARIABLE_YEAR>BASE_YEAR, VARIABLE_VALUE) ))

, VARIABLE_YEAR,VARIABLE_SEGMENT,PROCESS)

)

)

Or have a look at

Evaluating "sets" in the context of a dimension

for another approach