Set analysis with variable

[#1]

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

[mdmukramali]

Dear,

Instead of =GetCurrentSelections(_InvoiceA_Or_InvoiceB)

try

vInvoice  =Only(_InvoiceA_Or_InvoiceB)

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

[MayilVahanan]

Hi

Did you select any selections??

[#4]

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 !

[its_anandrjs · Accepted solution]

Try with in place of the  =GetCurrentSelections(_InvoiceA_Or_InvoiceB)

=GetFieldSelections(_InvoiceA_Or_InvoiceB)

And then write like

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

[ashfaq_haseeb]

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

[#7]

It works with this !

Thank you very much

[its_anandrjs]

Thanks I am Glad it works

Regards,

Anand

[smirkinaa]

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

[#10]

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)