Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Help

Hi All,

I created one varible in Notepad like this

Let v_CallActivities_Client_WK =sum([Call Count];

when i take this in to edit Script-->Insert-->Include state ment

im reload i am not getting that varible

some one help me

Thanks in Advance

rohith

7 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     Set v_CallActivities_Client_WK =sum([Call Count];

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ariel_klien
Specialist
Specialist

Hi

try

Let v_CallActivities_Client_WK =sum(Peek([Call Count]));


BR


Ariel

Not applicable

You are missing ) after sum([Call count]

it should be like this:

Let v_CallActivities_Client_WK =sum([Call Count]);

NavinReddy
Creator II
Creator II
Author

This Expression not working for me

plz check

LET v_CallActivities_Client_WK= sum({<[Date Key] = {">=$(=20130818)<=$(=20130824)"}>}[Call Count] )

Not applicable

i think ur variable needs an = infront of it, and maybe it should be SET

Not applicable

if u setup a variable inside qlikview then it should look like this:

vTest = =sum({<[Date Key] = {">=$(=20120507)<=$(=20120510)"}>} [Call Count])

This will give u the TOTAL sum for this period.

abeyphilip
Creator II
Creator II

Rohith,

But are you using this set analysis expression in your load script?

I don't think you can do that in your load script.

Regards,

Abey