topic Re: Set Analysis with a variable in the filters (possible?) in QlikView

Set Analysis with a variable in the filters (possible?)

Fri, 18 Jul 2014 13:58:55 GMT

Dears, I would like to do a set analysis using variables, but the variable would be the filter of the formula, for example:

This is the normal

=Sum({$<PRODUCT_FAMILY={"Family"}>}($(vInvoice))

I want to use the variable in the < > (in the place of PRODUCT_FAMILY)

How do I do that?

sudeepkm — Fri, 18 Jul 2014 14:01:01 GMT

EDIT:

surprising I added the variable inside but it didn't show up

=Sum({$<PRODUCT_FAMILY={"$(vInvoice)"}>}Sales)

=Sum({$<PRODUCT_FAMILY={""}>}Sales)

Fri, 18 Jul 2014 14:02:38 GMT

I would like to place the variable vInvoice inside the < >, instead of PRODUCT_FAMILY

but it is not working properly. How do I do that?

Fri, 18 Jul 2014 14:03:40 GMT

???

and how would it be using the PRODUCT_FAMILY?

alexandros17 — Fri, 18 Jul 2014 14:04:25 GMT

Unfortunately no ...

gmoraleswit — Fri, 18 Jul 2014 14:05:13 GMT

Declare a variable with the value : PRODUCT_FAMILY={"Family"}

Use it in your expression:

=Sum({$<$(vVar)>}($(vInvoice))

You can also use multiple variables:

=Sum({$<$(vVar),$(vVar2)>}($(vInvoice))

Fri, 18 Jul 2014 14:07:16 GMT

Have you tested it?

gmoraleswit — Fri, 18 Jul 2014 14:14:05 GMT

Yes, see attach

sudeepkm — Fri, 18 Jul 2014 14:16:22 GMT

I'm sorry I thought you are asking to have a field value taken from a variable.

but please take a look at the example.

I've declared a variable as Field name and used that in set analysis. I thought it would not work.