Sum of a value between two dates

whijo32 — Wed, 19 Jan 2022 19:30:16 GMT

I currently have two separate tables joined in Qlik. One has a report date with all the KPI's each day and the second table has a date of completion where an issue was addressed.

I am trying to measure the sum of a value 30 days before and 30 days after from the date of completion by using the data from the report date table.

I have two variables set up currently: v30DaysAfter = (Date of Completion+30) and v30DaysBefore = (Date of Completion-30).

I scrubbed through these forums to find similar issues and have a formula that is close to doing the job, but not quite working.

sum({$<DateOfCompletion = {">=$(DateOfCompletion)<=$(v30DaysAfter)"}>}VALUE)

and

sum({$<DateOfCompletion = {">=$(v30DaysBefore)<=$(DateofCompletion)"}>}VALUE)

When I run these two calculations, I am getting 0.00 for the sum of value when I'm just wanting to get the sum of value for 30 days before and then 30 days after.

Please let me know if I can provide to anymore information.

Re: Sum of a value between two dates

vikasmahajan — Thu, 20 Jan 2022 09:44:32 GMT

sum({$<DateOfCompletion = {">=$(DateOfCompletion)<=$(v30DaysAfter)"}> + <DateOfCompletion = {">=$(v30DaysBefore)<=$(DateofCompletion)"}> } VALUE)

Refer this https://community.qlik.com/t5/QlikView-App-Dev/quot-OR-quot-Condition-in-Set-Analysis/td-p/695709

https://community.qlik.com/t5/QlikView-App-Dev/AND-OR-combination-condition-in-set-analysis/td-p/786171

Thanks

Vikas

topic Sum of a value between two dates in App Development

Sum of a value between two dates

Re: Sum of a value between two dates