2 Replies Latest reply: Mar 21, 2013 8:12 PM by Cliff Perona RSS

    How to reference the value of an object in another object

      I am just testing out QlikView and it is very cool.

      I need to know if you can reference the output of one object as input to another?

       

      Example:

      Object "A" is a detached object showing the Total of all widgets

      Object "B" wants to use the total of all widgets in Object "A" to calculate the relative % of Object "B" values; e.g.  Hairdryer is 10% of total widgets sold.

       

      One reason for doing this is to be able to give a percentage of the total database and not just its relative parts.

      When I attempt to do percentages of a straight table I use the formula of: sum(value)/sum(total value) and mark the Expression tab as "relative" to get the line items as a percentage of the total. But that total is just for the relative items selected from the group.

       

      I need an absolute total to use.  maybe there is a better way.

       

      I need to show a table that when I select one of its parts it gives me the value of the selection relative to the absolute total of the database and not just to the items selected.

       

      Any ideas?

       

      Thanks!

      Italoman