Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
themandrake
Partner - Contributor II
Partner - Contributor II

Hi anyone knows a good set analysis syntax to calculate a sum on s"date from" ,"date to" fields to get the interval?

I could use the "slider" function on date but since it is kind of picky to get the selected date down to the date on the slider i choose to have two small multiboxes with two different dates, one is a generated "date from" the other one is the actual date field. on my calculation i have following syntax but it seems not to grip the interval. any suggestions?

sum({$<Date = {">=$(#=(Date_From))=$(#=max(Date))"}>} Value)

The Mandrake
1 Solution

Accepted Solutions
Not applicable

You can try this

Sum({$<Date={'>=$(Date_From) <=Max(Date)'}>} Value)

View solution in original post

2 Replies
Not applicable

You can try this

Sum({$<Date={'>=$(Date_From) <=Max(Date)'}>} Value)

themandrake
Partner - Contributor II
Partner - Contributor II
Author

Thx  worked like a charm

The Mandrake