topic Set analysis error in QlikView

Set analysis error

alec1982 — Wed, 28 May 2014 13:17:09 GMT

Hi guys,

Anybody could help me on this.

What could be wrong with this expression

Sum({$<Invoice_MonthYear={$(MaxYearMonth)}>}INVOICE_AMOUNT)

Knowing that $(MaxYearMonth)=201404.

If I replace the variable above with its value like:

Sum({$<Invoice_MonthYear={'201404'}>}INVOICE_AMOUNT) it returns the right value but when i replace it with the variable above it returns error!

Re: Set analysis error

Wed, 28 May 2014 13:18:27 GMT

try:

Sum({$<Invoice_MonthYear={$(=MaxYearMonth)}>}INVOICE_AMOUNT)

Re: Set analysis error

ashfaq_haseeb — Wed, 28 May 2014 13:20:35 GMT

try below

Sum({$<Invoice_MonthYear={$(=MaxYearMonth)}>}INVOICE_AMOUNT)

updated

Sum({$<Invoice_MonthYear={$(=Max(YearMonth))}>}INVOICE_AMOUNT)

Regards

ASHFAQ

Re: Set analysis error

alec1982 — Wed, 28 May 2014 13:21:11 GMT

Still the same error

Re: Set analysis error

Wed, 28 May 2014 13:22:37 GMT

share application

Re: Set analysis error

Anonymous — Wed, 28 May 2014 13:22:39 GMT

Maybe

Sum({$<Invoice_MonthYear={'$(MaxYearMonth)'}>}INVOICE_AMOUNT)

Re: Set analysis error

ashfaq_haseeb — Wed, 28 May 2014 13:24:09 GMT

like this

Sum({$<Invoice_MonthYear={$(=Max(Invoice_MonthYear))}>}INVOICE_AMOUNT)

Regards

ASHFAQ

Re: Set analysis error

alec1982 — Wed, 28 May 2014 13:39:27 GMT

I am still getting the error..

Unfortunately I cannot share the app. I have used the same expression somewhere else and it worked..Not sure if the expression is not recognizing the value of the variable..

Let me know your thoughts.. and thank you for all your help!

Re: Set analysis error

Wed, 28 May 2014 13:42:26 GMT

Please attach example. It is difficult to guess without a view...

Re: Set analysis error

PradeepReddy — Wed, 28 May 2014 13:49:56 GMT

try this....

Sum({$<Invoice_MonthYear={"$(=Max(YearMonth))"}>}INVOICE_AMOUNT)

If still not working.. pls share the application....

Re: Set analysis error

alec1982 — Wed, 28 May 2014 13:52:54 GMT

Here is a sample.. Thank you!

Re: Re: Set analysis error

ashfaq_haseeb — Wed, 28 May 2014 13:57:26 GMT

may be like this.

Regards

ASHFAQ

Re: Set analysis error

alec1982 — Wed, 28 May 2014 14:01:27 GMT

This worked for me. with no need for variables. Thank you!

Re: Set analysis error

Anonymous — Wed, 28 May 2014 14:02:07 GMT

This works for me:

=Sum({$<Invoice_MonthYear={"$(=$(MaxYearMonth))"}>} INVOICE_AMOUNT)