topic Re: Set analysis with variable in QlikView

Set analysis with variable

Mon, 30 Jun 2014 11:51:32 GMT

Hello everyone,

I have a problem with a set analysis using variable.

I want to change the calculation according to the user selection.

To do that, I made a selection with two values load by a load inline.

This two value are fields available in my script.

LOAD * INLINE [_InvoiceA_Or_InvoiceB

INVOICE_A

INVOICE_B

];

With this, I made a variable vInvoice with :

=GetCurrentSelections(_InvoiceA_Or_InvoiceB)

Thereafter, I write my set analysis like :

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

Unfortunately, my calculation doesn't work.

Is someone can help me ?

Thanks

Re: Set analysis with variable

mdmukramali — Mon, 30 Jun 2014 12:04:44 GMT

Dear,

Instead of =GetCurrentSelections(_InvoiceA_Or_InvoiceB)

try

vInvoice =Only(_InvoiceA_Or_InvoiceB)

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

Re: Set analysis with variable

MayilVahanan — Mon, 30 Jun 2014 12:06:24 GMT

Did you select any selections??

Re: Set analysis with variable

Mon, 30 Jun 2014 12:12:03 GMT

Hello,

Yes I select a selection

Thanks for your response.

I try

vInvoice =Only(_InvoiceA_Or_InvoiceB)

But it doesn't work either.

I wonder if my two values

INVOICE_A

INVOICE_B

are really link to my fields with the same name ?

Thanks !

Re: Set analysis with variable

its_anandrjs — Mon, 30 Jun 2014 12:14:24 GMT

Try with in place of the =GetCurrentSelections(_InvoiceA_Or_InvoiceB)

=GetFieldSelections(_InvoiceA_Or_InvoiceB)

And then write like

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

Re: Set analysis with variable

ashfaq_haseeb — Mon, 30 Jun 2014 12:20:28 GMT

Hi make sure values

INVOICE_A

INVOICE_B

Must have same name in table if not try be renaming your inline table field to match your source.

Regards

ASHFAQ

Re: Set analysis with variable

Mon, 30 Jun 2014 12:22:27 GMT

It works with this !

Thank you very much

Re: Set analysis with variable

its_anandrjs — Mon, 30 Jun 2014 12:28:48 GMT

Thanks I am Glad it works

Regards,

Anand

Re: Set analysis with variable

smirkinaa — Mon, 30 Jun 2014 12:45:50 GMT

Hi, one question, at what point is initialized variable "vInvoice"?

Re: Set analysis with variable

Tue, 01 Jul 2014 12:46:08 GMT

Hello,

The variable vInvoice is defined is the menu of QlikView application :

Then you create the variable "vInvoice", and for definition I typed :

=GetFieldSelections(_InvoiceA_Or_InvoiceB)