topic Re: set variable in QlikView

set variable

Wed, 23 Sep 2015 07:54:59 GMT

Hello,

I would like to set a variable in expression :

Expression :

sum({$<Round={'6'}>} Points)

instead of 6 the variable should be : vLast

vLast = Max({$<Played={'1'}>} Round)
I put it in a script (also tried in Variable overview)
SET vLast = Max({$<Played={'1'}>} Round).

but when I put
sum({$<Round={vLast}>} Points)
the expression is not working.
Separately expressions sum({$<Round={'6'}>} Points) and Max({$<Played={'1'}>} Round) are working.

Can somebody have any idea ?

Best thanks in advanced,

Re: set variable

alexandros17 — Wed, 23 Sep 2015 08:00:57 GMT

Try with

sum({$<Round={$(vLast)}>} Points)

sum({$<Round={$(=vLast)}>} Points)

let me know

Re: set variable

Wed, 23 Sep 2015 08:16:35 GMT

both doesn't work

Re: set variable

alexandros17 — Wed, 23 Sep 2015 08:22:14 GMT

Could you please share an example doc

Re: set variable

sunilkumarqv — Wed, 23 Sep 2015 08:31:37 GMT

sum({<Round= {"=(Max({$<Played={'1'}>} Round))"}>} Points)

sum({$<Round={"=$(vLast)"}>} Points)

Re: set variable

Wed, 23 Sep 2015 08:37:24 GMT

TRY :

sum({<Round={"=$(vLast)"}>} Points) OR

sum({<Round={'=$(vLast)'}>} Points)

khushboo

Re: set variable

nagarjuna_kotha — Wed, 23 Sep 2015 08:41:27 GMT

PFA...

Re: set variable

Wed, 23 Sep 2015 08:48:42 GMT

Please find attachment

Re: set variable

qlikmsg4u — Wed, 23 Sep 2015 08:52:18 GMT

try this its working

=sum({<Round={"=$(vLast)"}>} Points)

Re: set variable

tresB — Wed, 23 Sep 2015 08:55:37 GMT

Like this? PFA

Re: set variable

Gabriel — Wed, 23 Sep 2015 09:06:20 GMT

Hi,

The main issue with your variable is you're passing integer as strings using double quote.

If you remove the double quote from you integer your variables should work.

SET vLast = Max({$<Played={1}>} Round);

//Max({$<Played={1}>} Round) this is from variable overview

Re: set variable

sunilkumarqv — Wed, 23 Sep 2015 09:45:28 GMT

This works

sum({<Round={'$(=$(vLast))'}>}Points)

Re: set variable

Wed, 23 Sep 2015 09:47:44 GMT

Thank you all !!