Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
su88rao
Partner - Contributor III
Partner - Contributor III

By Default display max date values but upon diffrnt date selections need sum of selected date values

Hi ,

I have table which displays max date values by default. I have given expression as max date id by using calendar.

Requirement is now to display the above default as is, but when multiple dates are selected frm date filter for eg: if its 5th today and data displayed of only 5th and if date filter has 5th aug 4th aug and if both the dates are selected thn my table value should sum up  and display those values. 

i tried using if conditions but its not working

 

=if((DateID) = max(DateID),


Sum({<DateID={$(=Max(DateID))},Year={$(=Max(Year))}>}amount),

Sum({<Year={$(=Max(Year))},Month={$(=Max(Month))}>}amount))

please suggest where i am goin wrong

can anybody help me out on this

Thnks 

Labels (1)
1 Reply
miskinmaz
Creator III
Creator III

Instead of a mentioned if condition try to use the below condition:

if( getselectedcount(DateID)>0,...