topic Re: Help in QlikView

Help

NavinReddy — Thu, 29 Aug 2013 08:58:14 GMT

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

kaushiknsolanki — Thu, 29 Aug 2013 08:59:32 GMT

Hi,

Try this.

Set v_CallActivities_Client_WK =sum([Call Count];

Regards,

Kaushik Solanki

ariel_klien — Thu, 29 Aug 2013 09:02:12 GMT

try

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

Ariel

Thu, 29 Aug 2013 09:02:44 GMT

You are missing ) after sum([Call count]

it should be like this:

Let v_CallActivities_Client_WK =sum([Call Count]);

NavinReddy — Thu, 29 Aug 2013 09:52:02 GMT

This Expression not working for me

plz check

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

Thu, 29 Aug 2013 09:58:39 GMT

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

Thu, 29 Aug 2013 10:16:04 GMT

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 — Thu, 29 Aug 2013 10:16:51 GMT

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