topic Re: Requirement in QlikView

Requirement

deepakqlikview_123 — Wed, 30 Apr 2014 05:36:01 GMT

Hi all,

Please find attachment

As per requiremnet I need to show data in pivot table as

Field 2 data=feld 1 data+ field 2 data

Field 3 data=feld 1 data+ field 2 data + Field 3 data

Field 4 data=feld 1 data+ field 2 data + Field 3 data+Field 4 data

Can you please suggest what would be the formula for this

Please find QVW file there are month wise days and on combination of month and day there is count of sales.

I need to show data like

Day1 data data=Day 1 data+ Day 2 data

Day 3 data=Day 1 data+ Day 2 data + Day 3 data

Day 4 data=Day 1 data+ Day 2 data + Day 3 data+Day 4 data

Thanks

Re: Requirement

MK_QSL — Wed, 30 Apr 2014 05:37:35 GMT

Please provide data in excel file or in sample apps.

Re: Requirement

its_anandrjs — Wed, 30 Apr 2014 05:43:33 GMT

Please provide sample data otherwise you can achieve this requirement in the pivot tables.

Re: Requirement

deepakqlikview_123 — Wed, 30 Apr 2014 05:46:50 GMT

Please find QVW file there are month wise days and on combination of month and day there is count of sales.

I need to show data like

Day1 data data=Day 1 data+ Day 2 data

Day 3 data=Day 1 data+ Day 2 data + Day 3 data

Day 4 data=Day 1 data+ Day 2 data + Day 3 data+Day 4 data

thanks

Re: Requirement

deepakqlikview_123 — Wed, 30 Apr 2014 05:57:41 GMT

Hi anand,

PFA,Please suggest how to implement same in pivot table.

Thanks

Re: Re: Requirement

SunilChauhan — Wed, 30 Apr 2014 06:32:17 GMT

Hi Deepak.

use rangesum(above(sum(Amountfield)),0,rowno(Total)) in expr

see the attched file

hope this helps

Re: Requirement

deepakqlikview_123 — Wed, 30 Apr 2014 06:49:51 GMT

Hi Sunil,

Thanks for reply.

Currently my days are not rows I have taken them as a columns for same reason by using formula whatever u have mention I am getting sum for day 1 day2 only .

In this case can u plz suggest how to proceed,

Thanks