topic YTD with variable? in QlikView

YTD with variable?

Thu, 08 Sep 2011 18:03:05 GMT

Hi all.
I have a problem wit Set Analysis. I'm making a YTD calculation that Works fine as long as I don't use a variable to calculate. The function I'm trying to use look like this:

= sum({$<Month = {'<= $(v_MaxMonth)'}>} $(v_EB_Actual_KKR) )

If I use a fact instead of an variable it works fine.

Any ideas how to solve this?

Best Regards

/Kari

YTD with variable?

Thu, 08 Sep 2011 18:32:00 GMT

How the variable is defined?

YTD with variable?

Fri, 09 Sep 2011 06:07:22 GMT

The variable is complicated, it starts like this:

if(ReportRow_EB = 'Heating sales end customer, fixed fee'
,Sum({< EB_PURPOSE_CODE *= {'FAST','EFFEKT'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),

if(ReportRow_EB = 'Heating sales end customer, variable fee'
,Sum({< EB_PURPOSE_CODE *= {'FLÖDE', 'ENERGI', 'INGET'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),

if(ReportRow_EB = 'Heating sales distributors, fixed fee'
,Sum({< EB_PURPOSE_CODE *= {'FAST','EFFEKT'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),
.
.
.

YTD with variable?

gandalfgray — Fri, 09 Sep 2011 06:22:21 GMT

Hi Varis

Is it correct syntactically to have Sum inside Sum? - I have never used that as I can recall.

When I try it in a simple table chart it does not work anyway.

Re: YTD with variable?

gandalfgray — Fri, 09 Sep 2011 06:27:25 GMT

Hi Varis

try to move

Month = {'<= $(v_MaxMonth)'}

inside the set expressions in the v_EB_Actual_KKR variable

and remove the outer sum so the expression would just be:

= $(v_EB_Actual_KKR)

hth/gg

YTD with variable?

Fri, 09 Sep 2011 06:57:39 GMT

I tried to have Sum inside Sum and it didn't work, propably theere my error is.

Thank you for the help.