Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
absekrafi
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
Taoufiq_Zarra
Master II
Master II

@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
Taoufiq_Zarra
Master II
Master II

@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

absekrafi
Creator III
Creator III
Author

Thank you very much Taoufiq it works.

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