topic Re: values expression in QlikView

values expression

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

Hi All,

I have an expression as below

Defn: Code

sum({<Code={'$1'}>}Price) in my sublime .in the front end expression of qlikview Iam passing the value for $1.. Now I have an new requirement to sum few more codes ..

For Ex: Currently $1 --I was passing 41..

Now they need ..41,22,42,23..

suggest here please

Re: values expression

ogautier62 — Thu, 05 Jul 2018 08:11:40 GMT

Hi,

if you have few codes, and it doesn't change every day !

sum({<Code={'41','22','42' .......... }>}Price)

better to parametrize in a new table to load

code flag

41 1

22 1

40 0

etc

{<flag={1}

regards

Re: values expression

ujjwalraja — Thu, 05 Jul 2018 08:14:04 GMT

Hi,

You can pass multiple codes by defining continuous dollar sign parameters in your expression.

sum({<Code={$1,$2,$3,$4}>}Price)

Re: values expression

raadwiptec — Thu, 05 Jul 2018 08:18:18 GMT

ok guys i will try the suggestions and let you know