Multiple Values for Variable in Set Analysis

[brucejensen]

I have a variable vsxs1 that is used in the expression:

=Sum ({$<[Location Name]={'$(vsxs1)'}>}[Rent Amount])

This works fine if only one Location Name has been selected. Example vsxs1 = Building A

But it does not work if more than one Location Name has been selected. Example vsxs1 = Building A, Building B

Hoping there is an easy fix for this?

[idogridish2]

See this post:

https://community.qlik.com/t5/QlikView-App-Development/Concat-and-GetFieldSelections-to-use-in-Set-A...

BR,

Ido.

[brucejensen]

Sorry but this doesn't work.

[idogridish2 · Accepted solution]

Use it like this:

=Sum ({$<[Location Name]={$(vsxs1)}>}[Rent Amount])

and inside the variable:

=concat( distinct chr(39) & [Location Name],chr(39) &',') & chr(39)

[brucejensen]

That works! Thanks!