How to refer from a straight table to another table

[#1]

Hi all,

I just started using Qlikview for testing purposes whether the tool suits the companies requirements.

A layout has already be predefined that I´m currently try to create in Qlikview (to excuse myself in advance: I´m a controller without any programming skills).

The problems I´m facing right now is as follows:

Within a straight table I´d like to show the customers with the top 6 customers (dimension = customer) with the highest revenues.

1) How can I calculate the share (in %) of the customer on the total sales (all customers included)? I already tried it with the following expression:     "ACT 12"/sum(TOTAL {$<["Fiscal year"]={2012}>}["COAmount"])

But that only works when the table also shows the amount of all "other" customers which I´d like to avoid.

Does anybody know how i can refer to the total sales? Maybe by linking to another table that shows the total sales?

2) I got the same problem with the ranking: I´d like to show the ranking of the customers by sales revenue and compare it with the   ranking of the previous year. But within one straight table, qlikview only ranks the shown customers with 1-6 by using the following expression:     rank(sum({$<["Fiscal year"]={2011}>}["CO Amount"]))

Do I have to create another table and rank the customers first and then refer to this table? How can this be done?

Thank you very much in advance for your support!

[whiteline]

Hi.

You can use Dimension limits feature (tab) to limit the number of customers shown.

Also, there is no way in one table refer to another, you can only refer to expressions (including hidden columns) of the same chart.