Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

This works

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

View solution in original post

12 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try with

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

or

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

let me know

Not applicable
Author

both doesn't work

alexandros17
Partner - Champion III
Partner - Champion III

Could you please share an example doc

sunilkumarqv
Specialist II
Specialist II

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

or

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

Not applicable
Author

TRY :

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


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


khushboo

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

PFA...

Not applicable
Author

Please find attachment

qlikmsg4u
Specialist
Specialist

try this its working

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

tresesco
MVP
MVP

Like this? PFA