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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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