1 Reply Latest reply: Mar 19, 2013 12:56 PM by Alessandro Saccone RSS

    9 pivot tables in ONE chart? How would you solve it?

    Aissam Boumejjane

      Hi Guys,

       

      One of our customers requirement was to create a 'multiple pivot table' that would show all the differenttypes of calculations in one chart.

       

      What this charts displays is a summery (management) report of different caclulations (e.g. Financial, Performance, FTE), same management report as microsoft Excel.

       

      Since this is not possible to achieve within Qlikview, I solved this using an inline table. Since I don't have any dimensions (except from the inline table), I have to use IF for each calculation. There are more than 70 IF staments in my expression, which really makes it difficult to maintain.

       

      I was wondering if there isn't a more sufficient way to solve the above matter the customers need?

       

      Attached is a screenshot sample. Since it contains management info I had to scramble the description.

       

      Looking forward for all of your ideas/input

       

      Regards,

       

      Sam