Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
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