Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
zhadrakas
Specialist II
Specialist II

maybe this

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

Not applicable
Author

Error: Error in expression:

')' expected

tamilarasu
Champion
Champion

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])

Not applicable
Author

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

tamilarasu
Champion
Champion

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