topic Re: Variables in QlikView

Variables

Mon, 03 Apr 2017 07:20:39 GMT

Hi there, this is the part in my script that creates the set analysis part:

Let vCurrentCycle = Peek('Cycle Calendar Period',0,'Cycles');

Let vPrevMonthCycle = vCurrentCycle-1;

let vPrevYearCycle = vCurrentCycle-100;

Let vEFT_VOL_CP = '{<[Cycle Calendar Period]={$(vCurrentCycle)}>}';

Let vEFT_VOL_PP = '{<[Cycle Calendar Period]={$(vPrevYearCycle)}>}';

Let vEFT_VOL_CP = '{<[Cycle Calendar Period]={$(vPrevMonthCycle)}>}';

in my equation i'm trying this:

=sum( {$<$(vEFT_VOL_CP)>} [EFT Volume]), i have tried the following variations as well.

=sum( {$<'$(vEFT_VOL_CP)'>} [EFT Volume])

=sum( {$<{'$(vEFT_VOL_CP)'}>} [EFT Volume])

what is it i'm doing wrong.

zhadrakas — Mon, 03 Apr 2017 07:31:26 GMT

maybe this

=sum('$(vEFT_VOL_CP)' [EFT Volume] )

Mon, 03 Apr 2017 07:40:10 GMT

Error: Error in expression:

')' expected

tamilarasu — Mon, 03 Apr 2017 07:46:00 GMT

Hi Stephan,

Try this,

Let vEFT_VOL_CP = '{$<[Cycle Calendar Period]={$(vCurrentCycle)}>}';

Let vEFT_VOL_PP = '{$<[Cycle Calendar Period]={$(vPrevYearCycle)}>}';

Let vEFT_VOL_CP = '{$<[Cycle Calendar Period]={$(vPrevMonthCycle)}>}';

=Sum($(vEFT_VOL_CP) [EFT Volume])

Mon, 03 Apr 2017 07:56:10 GMT

i figured out my error, i created 2 variables with the exact same name

tamilarasu — Mon, 03 Apr 2017 08:00:04 GMT

Glad you found the mistake. I thought it was a typo. Have a nice day!!