Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

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 

1 Reply
miskinmaz
Contributor III

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

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

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