# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Valued Contributor

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

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?

Tags (2)
1 Solution

Accepted Solutions
MVP

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

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.

4 Replies
MVP

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

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.

Valued Contributor

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

Hi Swuehl,

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

Not applicable

MVP

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

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.