topic Variable With Hard Coded Values in QlikView

Variable With Hard Coded Values

azmeerrehan — Mon, 17 Sep 2018 16:22:52 GMT

I have a set analysis Expression as

SUm({<Product={'A','B','C'}>} Sales)

I would like to place the A,B, C in a variable so in future if the requirements change then we can change the variable value and won't have to edit every single expression .

I created a variable vProduct as "A"CHR(44)"B"CHR(44)"C"CHR(44). Its not working .

Can someone help

Re: Variable With Hard Coded Values

vishsaggi — Mon, 17 Sep 2018 16:28:17 GMT

May be in your variable store like below

vProduct = 'A','B','C'

Then in your expr

= Sum({<Product = {$(vProduct)} >} sales)

Re: Variable With Hard Coded Values

captain89 — Mon, 17 Sep 2018 17:12:38 GMT

try this:

vProduct=chr(39)&'A'&chr(39)&chr(44)&' '&chr(39)&'B'&chr(39)&chr(44)&' '&chr(39)&'C'&chr(39)