Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression working in 11 but not in 12 in qlik sense

The below expression is working fine in version 11 but once i upgraded, it is not working.

Sum({$<[AR.Date]={$(vMaxDate)}>}[AR - Value])

Defined vMaxDate=Max([AR.Date])

Someone help to resolve?

3 Replies
eliran
Creator III
Creator III

Hi Iswarya,

Try using the below:

vMaxDate=date(Max([AR.Date]))

Sum({$<[AR.Date]={'$(vMaxDate)'}>}[AR - Value])

Please mark correct if it helped you.

BR,

Eliran.

Not applicable
Author

Ya it is working. Thanks a lot Eliran.

Anil_Babu_Samineni

Qliksense as i know only 3rd version is running. But, Your title telling us Qlik sense. Can you confirm the same?

And, I am assuming Qlikview 12 it is bug but it should work. Can you show the error message you got. It will show as error on expression because you are validating to the field. That is the way it will.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful