Running total in bar chart

Saro_2306 — Mon, 08 Feb 2021 17:35:53 GMT

Hi all,

I am having 8 weeks data of 4 team each team having 5 members. I need to show running total of Production % of users in bar chart with selection of Team name and Week number.

Production % = Production units / Working Days.

When I Select week 1 it should show week 1 Production % of users.

When I select Week 2 it should show Production % of week 1 + Production % of week 2, as like for rest of weeks.

for above calculation I have written formula as like below.

sum({<[Week Num]={">=$(=(week(Yearstart(Max([Week Num]))))) <=$(=Max([Week Num]))"}>} AGGR(sum({1}[Production Units]),Team,[Week Num]) / Aggr(sum({1}[Working Days Count]),Team,[Week Num]))

What is my problem is when I select week 1 it shows only 1 user name in bar chart and 2 user name when I select week 2.

Can anybody advise where is mistake happens. Thanks in Advance.

Re: Running total in bar chart

edwin — Mon, 08 Feb 2021 19:14:07 GMT

this is a great place to start:
Running totals per dimension (RangeSum(), sortable... - Qlik Community - 1487351

topic Running total in bar chart in QlikView

Running total in bar chart

Re: Running total in bar chart