Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I need a graph to display as below
I am still not having luck with this. Any insight would be appreciated.
Thanks.
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?