Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Total Qty for records with X Days in a Bar Graph

If anyone could provide the Expression required in the chart, I really appreciate it. I am evaluating the Personal Edition and need to make sure this can be accomplished.

Please provide expression in response and not attached file.

Objective:

I need to Total the order Qty for "Filtered" orders in a bar graph for a period defined by the user.

I have created a variable vSumDays to determine the number of days that need to be Aggregated. The filtered data is displayed below.

Thanks!

error loading image

I need a graph to display as below

error loading image

2 Replies
Not applicable
Author

I am still not having luck with this. Any insight would be appreciated.

Thanks.

Not applicable
Author

Qlikview experts, John - Anyone? Please help!

I am spending an incredible amount of time while I'm sure it is probably a VERY easy thing to do. I just do not know how.

I have tried:

rangesum(Above(sum(Qty),0,vSumDays)) - This sum's the next vSumDays records even if outside of the date range

sum({$<OrderDate += {$(=Date(OrderDate + vSumDays))} >} Qty) - This just brings back each record?

sum({<OrderDate={"=>$(=OrderDate) <=$(=Date(OrderDate + vSumDays))"}>} Qty) - This brings back NOTHING?