values expression

[raadwiptec]

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

[ogautier62]

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

[ujjwalraja]

Hi,

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

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

[raadwiptec]

ok guys i will try the suggestions and let you know