6 Replies Latest reply: Dec 24, 2014 5:59 AM by Jeroen Jordaan RSS

    Total of the top x items and total of the total in straight (or pivot) table

    Jeroen Jordaan

      Hi all,

       

      A customer wanted to have an additional table in his QlikView application.

      The customer wants to see the top 10, 20, 30 etc (depends on the value of the variable) items.

      Besides that the customer wants to see the total of the top 10, 20, 30 etc items but he also wants to see the total of the total (all the items)

       

      In the beginning I thought that is not so difficult.

      We can use dimension limits. But with this feature we cannot show the total of the top 10, 20, 30 etc items. We can show the total of the total.

       

      Then I tried to use the Max number setting in the presentation tab. With this I only see the total of the total and not the total  of the  top 10, 20, 30 etc items

       

      So I thought lets use the aggr function in a calculated dimension. But with this solution we can only show the total of top 10, 20, 30 etc items and not the total of the total.

       

      Am i missing something?

      Has anyone ran into this requirement and found a solution for it?

       

      Thanks in advance