Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Employee
Employee

Limit a Dimension based on measure not in the chart

I have a line chart.  A dimension of Territory and a measure.

I want to limit the Territories that are displayed based on a different measure that is not displayed in the chart and use the limitation property to just display the top 5 territories based on this measure.  But in the chart display the measure values for the main measure.

The limitation property appears to only default to the measure that is in the chart and doesn't allow me to use a different measure.

Is there a way around this?

1 Reply
Highlighted
Contributor III
Contributor III

Use the desired measure to create a flag on top 5 Territories in back end script and use the flag in set analysis of Territories Dimension.

Aggr(only({< Top5Territories  = {1}>}Territories ),Territories )