topic Re: error in expression in QlikView

error in expression

master_student — Tue, 05 Dec 2017 13:27:31 GMT

Hello Guys,

I have en error in my expression bellow :

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1)},[Calendar date]={"<$(=Date(AddYear(Today(),-1))"}>} recharge_amount),'# ##0')

Colin-Albert — Tue, 05 Dec 2017 13:31:51 GMT

There is a missing bracket

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1) }, [Calendar date]={"<$(=Date(AddYear(Today(),-1)) ) "}>} recharge_amount),'# ##0')

Anil_Babu_Samineni — Tue, 05 Dec 2017 13:34:00 GMT

Could be anyone of these?

=num(sum( {$<[Year of date]={$(=Max([Year of date])-1)},[Calendar date]={"<$(=Date(AddYears(Today(),-1)))"}>} recharge_amount),'# ##0')

=num(sum( {$<[Year of date]={'$(=Date(Max([Year of date])-1))'},[Calendar date]={"<$(=Date(AddYears(Today(),-1)))"}>} recharge_amount),'# ##0')

prashantsanchet — Tue, 05 Dec 2017 13:41:07 GMT

Hope this will help:

num(Sum({<[Year of date] = {"= Max([Year of date])-1" },[Calendar date]={"<$(=Date(AddYear(Today(),-1))"} >}recharge_amount),,'# ##0')

Colin-Albert — Tue, 05 Dec 2017 13:48:35 GMT

Prashant - To evaluate a function within a set expression you need to enclose the expressions in $(= )

so = Max([Year of date])-1 will not work, $(= Max([Year of date])-1 ) is correct.

Assuming that the field [Year of date] is numeric, there is no need to enclose the set modifier value in quotes.

The error is due to the brackets not matching in the second modifier for Calendar Date

master_student — Tue, 05 Dec 2017 14:08:42 GMT

Thanks a lot. all of you