topic Re: Variable to hold multiple values in QlikView

Variable to hold multiple values

Anonymous — Fri, 22 Jul 2016 02:45:38 GMT

Hi,

I want a variable to store multiple product values so that I don't have to manually enter all the products like

Sum({<Product={'A','B,'11','121','DD','E'}>}TotalDue)

Instead I want to define a variable to hold different categories of products.

For instance, vProductCategory1 to match only Product "A", "B", and "121" so that I can use

Sum({<Product={vProductCategory1'}>}TotalDue).

So, how do I enter multiple values on a variable? Does below look right? Separate values by a semicolon inside single quotes?

Thanks.

Fri, 22 Jul 2016 02:50:19 GMT

Please find attached the solution.

Fri, 22 Jul 2016 02:55:20 GMT

What you do is almost correct.

To define the variable as

'A','B','121'

To get the calculation using expression

Sum({<Product={ $(vProductCategory1) }>}TotalDue)

maheshkuttappa — Fri, 22 Jul 2016 03:26:07 GMT

It will be common separated values

vProductCategory1

Definition= 'A','B,'121' or A,B,121

your Expression will be

Sum({<Product={$(=vProductCategory1)}>}TotalDue).