Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using variables in set expressions

I have the following expression:

Sum({<Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, [PLUS FIVE],[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>} Amount)


I want to replace  Sum(Amount) with a variable vSetTotalAmount


How can the above expression be changed to accommodate the variable?


Regards.

1 Solution

Accepted Solutions
sunny_talwar

As far as I know, this is not doable.

View solution in original post

4 Replies
sunny_talwar

As far as I know, this is not doable.

Anonymous
Not applicable
Author

Many thanks Sunny

Regards.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm not sure how you want the end to look, but you fill any parts of an expression using variables.

$(vFunction)({<Applicant = {[SANOFI AVENTIS], GLAXOSMITHKLINE, PFIZER, NOVARTIS, [PLUS FIVE],[NOVO NORDISK], RANBAXY, IPCA, ALCON, GLENMARK, MYLAN, VARICHEM, [CIPLA], ALLERGAN}>} $v(FunctionField))

Anonymous
Not applicable
Author

Thanks, Rob, i will look into that as recommended.

Regards.