How to get the dimension values of one chart in another chart in qlikview?

[udaya_kumar]

Hi,

I have two charts, both are having same dimension but different expressions.

In first chart, i will get the top 10 largest values, so i will get 10 values of dimension, i want to get those 10 values in the second chart dimension.

how do i get the top 10 values of first chart dimension in second chart dimension?

[swuehl · Accepted solution]

Looking at this given example, you could create a calculated dimension

=aggr( if(rank(sum(ValueField))<=10,DimensionField), DimensionField)

You could also use a set expression with an advanced search in all your expressions to limit the second table to the same dimensions values.

[udaya_kumar]

Hi Swuehl,

Do i need to use this expression for the second chart dimension or first chart dimension?

[#4]

Awesome, Correct answere

[swuehl]

Udaya,

you could actually use it for both, it will limit Dimensionfield to the values where sum(ValueField) is under the top 10.

But since you already have your first chart, my intention was to use it for the second chart.

A calculated dimension may show not so good performance on large data, so you might want to have a look into using set analysis with all your expressions in the second chart and just DimensionField as dimension.

But to help you more with the set expressions, we need more details about your data model, dimensions and expressions in your two charts.