Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Saro_2306
Contributor II
Contributor II

Running total in bar chart

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.

 

1 Reply
edwin
Master
Master