Partial sum and %

[#1]

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

[#2]

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

[#3 · Accepted solution]

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

BR

Omer

[#4]

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.