Accumulate data at different levels

[#1]

Hi All,

I hv a req..as below..

User needs count of weeks at Year, Quarter, Month and employee level. When user selects 2nd Month, it has to include 1st month count of weeks and 2nd month count of weeks. In this ex, we hv 5 for 1st month and 6 for 2nd month, it results 5+6=11 count of weeks. In the same way when user selects Quarter, it has to fetch count of weeks for that quarter etc...

I dont want quarter level now...if it is month level am fine.

I appreciate for your gr8 help

I have Month and count of weeks column

Now i have count of weeks for every month.

Requirement:                                                                

Month	Count of weeks
1	5
2	6
3	7
4	9
5	4
6	6
7	1
8	4
9	3
10	7
11	8
12	2

[maxgro]

like this?

if yes cum expression is

sum({$ <Month={"<=$(=max(Month))"}>} [Count of weeks])

[#3]

Hi Grossi,

No, its not like this...i already know this approach. Try to select any

month in your example and see the result

If u select 5th month..it should show sum(1st month to 5th month count of

weeks).. try this ...u understand my requirement..

anyway thanks for your quick reply

On Thu, Sep 18, 2014 at 12:40 AM, Massimo Grossi <qcwebmaster@qlikview.com>

[maxgro]

I selected one month (6), in image the result; if you want a different result try to explain it, maybe someone else will

answer

[Anonymous]

try this

=Sum({<Month={">=$(=Min({<Month=>} Month)) <= $(=Max(Month))"}>}weeks)

[#6]

As we know that if there are 12 rows its showing running total for all rows/records.

But my requirement is if user selects 2nd month that has to show 1st month records (ex: Jan - count of weeks (5)) + 2nd month records(Ex: Feb(4)) total should be 5+4=9. in this way wherever the user selects a month from that month to previous all months give the data.

Ex: jan=5

feb=4

mar=5

Apr=4

User selected April month that is equal to = Jan+Feb+Mar+Apr=5+4+5+4=18 records.

Please let me know if you need more clarification. thank you.

[Anonymous]

did you check the app I provided?

[#8]

No Kozins..i will let you know about it.. thanks

[#9]

Hi All,

I have another req... as i have null values at DB level...i would like to get the null records count at report level..

anybody has done earlier on this?

Thanks in advance..