topic Error message in QlikView

Error message

tellmalaika17 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

While using below expression, getting an error as "error in expression ')' expected".

=num(sum({$<month={$(=max(month))}>}
Sales/1000000)/ num (right ($(=max(month)),2))
//*12,'#,##0')

The above expression gives error only when there is no data. I want it to display 'No data to display' or show '0' when there is no data but unable to change this in error message.

Appreciate any help in this regard.

Thanks,

Re: Error message

devarasu07 — Thu, 23 Nov 2017 01:31:24 GMT

Hi,

may be this?

=num(sum({$<month={$(=max(month))}>}Sales/1000000)/right($(=max(month)),2),'#,##0')

Regards,

Deva

Re: Error message

sumanta12 — Thu, 23 Nov 2017 05:14:09 GMT

=num(sum({$<month={$(=max(month))}>}Sales/1000000)/ num (right ($(=max(month)),2)),'#,##0')

Re: Error message

Anil_Babu_Samineni — Thu, 23 Nov 2017 05:24:47 GMT

do you mean to display error message using condition from General Tab??

Re: Error message

avinashelite — Thu, 23 Nov 2017 05:28:59 GMT

where your using this expression ??? to show the error message or in the expression ?

Re: Error message

tellmalaika17 — Thu, 23 Nov 2017 16:00:09 GMT

doesn't work

Re: Error message

tellmalaika17 — Thu, 23 Nov 2017 16:00:17 GMT

yes

Re: Error message

tellmalaika17 — Thu, 23 Nov 2017 16:01:02 GMT

using this expression in a text object... the denominator is not getting evaluated since the month has '-' value.

Re: Error message

tellmalaika17 — Thu, 23 Nov 2017 16:01:14 GMT

Tried still doesn't work...

Re: Error message

Anil_Babu_Samineni — Thu, 23 Nov 2017 16:37:03 GMT

The above expression gives error only when there is no data. I want it to display 'No data to display' or show '0' when there is no data but unable to change this in error message.

WWhat is that mean which i highlighted one?

Re: Error message

Peter_Cammaert — Thu, 23 Nov 2017 17:09:14 GMT

If your data is complete (months for all facts), then month shouldn't result in '-' but in a lot of different values. Max(Month) will pick the highest month even if you haven't explicitly selected any data (=everything is selected), on condition that either Month is numerical to begin with or month is a dual value with a valid numerical component. Otherwise Max() will return NULL because it is unable to enumerate month values and decide which one is the highest...

Are you sure that month isn't filled with text-only values?

Re: Error message

rugveddhuri — Thu, 23 Nov 2017 18:45:37 GMT

Hi,
Can you try this?

=Num(Sum({$<month={$(=Max(month))}>}

Sales/1000000)/ Num (Right ($(=If(IsNum(Max(month)),Max(month),1)),2))

*12,'#,##0')