topic Re: Show accumulate in pivot table in QlikView

Show accumulate in pivot table

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I have this table:

And I need show month and accumulate:

Any help, please?

Thanks.

Re: Show accumulate in pivot table

mromrod22 — Fri, 17 Mar 2017 11:43:06 GMT

Also I want know if is possible apply the same style (each row of a color).

Re: Show accumulate in pivot table

neha_shirsath — Fri, 17 Mar 2017 11:47:41 GMT

Hi,

Can you post some sample data,that will more helpful to find the solution.

Thanks,

Neha

Re: Show accumulate in pivot table

Anil_Babu_Samineni — Fri, 17 Mar 2017 12:02:04 GMT

It is possible, If you provide data.

Or simple create

Then create One Pivot Chart

Dimensions are --

[Numero Solictudos],

ValueList('1 enero - 18 Febero 2017','Febero 2017')

Then Call Two expressions by the Label of N2, % and then Drag ValueList dimension from vertical to horizontal in the top of the Pivot table. Then you will achieve it

Then call BG color to give automate color rows If(Mod(Rowno(),2)=1, White(), Blue())

Give as Dimension BG Color and then Same with 2 expressions.

And then Go to Presentation Tab --> Then Call Total as TOTAL SOLICITUDIES PLANIFICADAS

Good Luck , You will do it

Re: Show accumulate in pivot table

mromrod22 — Fri, 17 Mar 2017 12:56:54 GMT

Attach a reduced exampled.

This is all that I can do it.

Re: Show accumulate in pivot table

mromrod22 — Mon, 20 Mar 2017 07:36:37 GMT

Attach a reduced example.

Thanks.

Re: Show accumulate in pivot table

Anil_Babu_Samineni — Mon, 20 Mar 2017 07:41:10 GMT

14 MB, I don't have access to download AON due to client location. So, here create sample inline memory and then tell us your expected output like above(Original message)

Re: Show accumulate in pivot table

mromrod22 — Tue, 21 Mar 2017 07:28:20 GMT

!Update.

I got a table with accumulate, but in some month, not works correctly. Attach the reduced example, when you can see in 'Mar' month that not accumulate (loses data). In a simple table can see that data that I lose is repeated data.

Thanks for the help.

Regards.

Re: Show accumulate in pivot table

sunny_talwar — Tue, 21 Mar 2017 08:21:53 GMT

What is wrong with the output you are seeing? Can you share the desired output for Mar?

Re: Show accumulate in pivot table

mromrod22 — Tue, 21 Mar 2017 08:58:30 GMT

Expected output of 3 first months (Bold -> accumulate)

January:

P.A. - 36 36

P.S. - 1 1

P.P. - 3 3

A - 0 0

TOTAL - 40 40

February:

P.A. - 71 107

P.S. - 9 10

P.P. - 19 22

A - 5 5

TOTAL - 104 144

Mar:

P.A. - 142 249

P.S. - 9 19

P.P. - 44 66

A - 14 19

TOTAL - 209 353

In this month loses data.

Re: Show accumulate in pivot table

beck_bakytbek — Tue, 21 Mar 2017 09:52:45 GMT

Hi Ramano,

check this video-topic: https://www.youtube.com/watch?v=zIVj4U9QqPQ

i hope that helps

beck

Re: Show accumulate in pivot table

mromrod22 — Thu, 23 Mar 2017 08:10:10 GMT

HELP ME PLEASE!