topic Re: Multiple Values for Variable in Set Analysis in QlikView

Multiple Values for Variable in Set Analysis

brucejensen — Sat, 16 Nov 2024 01:59:27 GMT

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 — Fri, 08 Nov 2019 18:54:56 GMT

See this post:

BR,

Ido.

brucejensen — Fri, 08 Nov 2019 19:01:16 GMT

Sorry but this doesn't work.

idogridish2 — Fri, 08 Nov 2019 19:11:50 GMT

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 — Fri, 08 Nov 2019 19:24:05 GMT

That works! Thanks!