Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
matbelli
Contributor
Contributor

Set analysis in a variable time window

Hi, i need to calculate the sum of an import in a time window of 30 days, that user can choose clicking on the date.

So i have to click on one day and it should calculate the sum of these values in case the field is ACQ/VIN= 'ACQUISTO' in the previous 30 days.

How can i do it?

 

1 Reply
Anil_Babu_Samineni

Perhaps this?

Sum({<ACQ/VIN= {'ACQUISTO'}, DateField={">=$(=Date(Max(DateField-30),'DateFormat'))<=$(=Date(Max(DateField),'DateFormat'))"}>} Value)

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