Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

udaya_kumar
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
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
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.

udaya_kumar
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

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

Awesome, Correct answere

MVP
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.

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

Community Browser