topic Re: When using a variable for expression, cannot pass string with comma in QlikView

When using a variable for expression, cannot pass string with comma

djbloiss — Wed, 25 Nov 2020 16:16:04 GMT

I am using a variable to save my expressions, so I can reuse them in multiple places and change them all easily. So I have this one expression saved as a variable:

Sum({<$1, $2, $3>} [Actual Quantity])

that I then use in multiple places. here is a place that I call it and it works fine passing multiple arguments:

$(e_Cases($(vSO_Closed_Only), InternalSlsFlag={0}, Node1={'Diner Sales'}))

then I just used it here:

$(e_Cases($(vSO_Closed_Only), [Originating cl for order]={'D','P','B'}))

and it doesn't work. Odd. So I do some testing. If I remove 2 of the 3 filters from the second argument, it then works. So this will work:

$(e_Cases($(vSO_Closed_Only), [Originating cl for order]={'D'}))

or this:

$(e_Cases($(vSO_Closed_Only), [Originating cl for order]={'B'}))

How can I get it so all 3 can be passed?

Re: When using a variable for expression, cannot pass string with comma

sunny_talwar — Thu, 28 Dec 2017 17:20:52 GMT

See if this helps

Comma problem (,) workaround for dollar sign expansion with parameters

Re: When using a variable for expression, cannot pass string with comma

marcus_sommer — Fri, 29 Dec 2017 07:09:39 GMT

Commas within variable-parameters are always a problem which could be partly solved with various workarounds like hinted from Sunny. In your case you don't need mandatory the commas because you could replace your value-list with a search-string like (D|P|B).

- Marcus