Set Analysis expression error

[absekrafi]

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 · Accepted solution]

@absekrafi 

and if vMaxDate=Date(Max(DATE_T))

and

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

?

[absekrafi]

Thank you very much Taoufiq it works.

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