topic Partial sum and % in QlikView

Partial sum and %

Wed, 18 Jan 2012 10:50:53 GMT

Hi all,

I have to replicate in qlikview the following excel table:

where % is, for activity a1 to a6, related to "Tot A" and for activity a7 is related to "Tot B"

I have a qlik table with activity a1 to a8 with value h but I not able to find % per row, do I have to use something like "aggr"?

thank you in advance

Wed, 18 Jan 2012 10:57:55 GMT

Hi all,

I have to replicate in qlikview the following excel table:

-------------------------------------------------------------

| activity | h | % |

-------------------------------------------------------------

| a1 | 862,00 | 49,91% |

| a2 | 100,00 | 5,79% |

| a3 | 264,00 | 15,29% |

| a4 | 42,00 | 2,43% |

| a5 | 91,00 | 5,27% |

| a6 | 368,00 | 21,31% |

| Tot A |1727,00| |

| a7 | 157,00 | 8,33% |

| Tot B |1884,00| |

| a8 | 257,00 | |

| Tot |2141,00| |

-------------------------------------------------------------

where % is, for activity a1 to a6, related to "Tot A" and for activity a7 is related to "Tot B"

I have a qlik table with activity a1 to a8 with value h but I not able to find % per row, do I have to use something like "aggr"?

thank you in advance

Wed, 18 Jan 2012 11:50:29 GMT

Hi Carlo,

I attach a document about your question.. 2 create two pivot table for 2 different scenarios to calculate %.

i hope it will help you..

Omer

Wed, 18 Jan 2012 15:57:03 GMT

It works! the first scenario is what I was needing

Thank you very much for the time you spent on this.

Kind regards

Carlo A.