topic Re: Set Analysis expression error in QlikView

Set Analysis expression error

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

Dear Qlikview community,

I have the expression : =num(Sum({<DATE_T={$(vMaxDate)}>} QTE_ITEM_MP),'# ##0') where vMaxDate=Max(DATE_T)

I have the error : Error in set modifier ad hoc element list : '.' or ')' expected.

Can you help me out with the problem?

Thank you very much,

Abdallah

Taoufiq_Zarra — Mon, 19 Oct 2020 13:48:04 GMT

and if vMaxDate=Date(Max(DATE_T))

and

=num(Sum({<DATE_T={'$(vMaxDate)'}>} QTE_ITEM_MP),'# ##0')

absekrafi — Mon, 19 Oct 2020 14:10:33 GMT

Thank you very much Taoufiq it works.

I tried both vMaxDate=Max(DATE_T) and vMaxDate=Date(Max(DATE_T)) and it worked fine.