Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
Set v_CallActivities_Client_WK =sum([Call Count];
Regards,
Kaushik Solanki
Hi
try
Let v_CallActivities_Client_WK =sum(Peek([Call Count]));
BR
Ariel
You are missing ) after sum([Call count]
it should be like this:
Let v_CallActivities_Client_WK =sum([Call Count]);
This Expression not working for me
plz check
LET v_CallActivities_Client_WK= sum({<[Date Key] = {">=$(=20130818)<=$(=20130824)"}>}[Call Count] )
i think ur variable needs an = infront of it, and maybe it should be SET
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.
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