topic Re: Accumulate data at different levels in QlikView

Accumulate data at different levels

Wed, 17 Sep 2014 18:55:25 GMT

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

Re: Accumulate data at different levels

maxgro — Wed, 17 Sep 2014 19:09:32 GMT

like this?

if yes cum expression is

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

Re: Accumulate data at different levels

Wed, 17 Sep 2014 19:40:32 GMT

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>

Re: Accumulate data at different levels

maxgro — Wed, 17 Sep 2014 20:18:53 GMT

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

answer

Re: Accumulate data at different levels

Anonymous — Wed, 17 Sep 2014 20:43:02 GMT

try this

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

Re: Accumulate data at different levels

Fri, 19 Sep 2014 12:44:36 GMT

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.

Re: Re: Accumulate data at different levels

Anonymous — Fri, 19 Sep 2014 12:50:03 GMT

did you check the app I provided?

Re: Re: Accumulate data at different levels

Fri, 19 Sep 2014 12:59:04 GMT

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

Re: Accumulate data at different levels

Tue, 23 Sep 2014 09:53:59 GMT

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..