Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

set variable

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,

1 Solution

Accepted Solutions
sunilkumarqv
Valued Contributor II

Re: set variable

This works

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

12 Replies

Re: set variable

Try with

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

or

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

let me know

Not applicable

Re: set variable

both doesn't work

Re: set variable

Could you please share an example doc

sunilkumarqv
Valued Contributor II

Re: set variable

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

or

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

Not applicable

Re: set variable

TRY :

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


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


khushboo

nagarjuna_kotha
Valued Contributor II

Re: set variable

PFA...

Not applicable

Re: set variable

Please find attachment

qlikmsg4u
Valued Contributor

Re: set variable

try this its working

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

MVP
MVP

Re: set variable

Like this? PFA

Community Browser