Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Set Analysis expression error

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

1 Solution

Accepted Solutions
Highlighted
Master
Master

@absekrafi 

and if vMaxDate=Date(Max(DATE_T))

and

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

?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Highlighted
Master
Master

@absekrafi 

and if vMaxDate=Date(Max(DATE_T))

and

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

?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Highlighted
Creator III
Creator III

Thank you very much Taoufiq it works.

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