Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

1 Solution

Accepted Solutions

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

HI

Try like this

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

Hope it helps

2 Replies

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

HI

Try like this

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

Hope it helps

Not applicable

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

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

thank you!

Community Browser