3 Replies Latest reply: Jan 18, 2012 10:57 AM by Carlo A. Babini RSS

    Partial sum and %

      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

        • Partial sum and %

          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