How to reference the value of an object in another object

Thu, 21 Mar 2013 23:55:11 GMT

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

Re: How to reference the value of an object in another object

MayilVahanan — Fri, 22 Mar 2013 00:05:49 GMT

Try like this

sum(value)/sum({1}total value)

Hope it helps

Re: How to reference the value of an object in another object

Fri, 22 Mar 2013 00:12:10 GMT

Works fine -- did not realize QV is so powerful. The more I see the more I like.

thank you!

topic How to reference the value of an object in another object in QlikView

How to reference the value of an object in another object

Re: How to reference the value of an object in another object

Re: How to reference the value of an object in another object