Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jitin
Partner
Partner

How to Limit second dimension of a drill down

Hello Everyone,

I am new to Qlik Sense and I am facing issue in below requirement. Please help!!

I have a drill down dimension "CountryState" having two dimensions "Country" and "State" and the measure is sales.

I have to show the drill down in the bar chart in a way when initially the chart is loaded then all the Country should be visible showing Sum(Sales) of each country. And when we select a country in the chart then it should show me Sum(sales) of only top 5 cities.

Found a few solution with GetCurrentField method but it does not work in Qlik Sense.

Labels (1)
3 Replies
arulsettu
Master III
Master III

Check this sample

 

Jitin
Partner
Partner
Author

Thanks Arulsettu. But I donot have licence for Qlik sense so I will not be able to load the qvf file.

If possible could you please explain the solution in relpy.

Thanks in advance.

arulsettu
Master III
Master III

While creating drilldown use the below calculated dimension for city

 

if(aggr(rank(sum(sales),4),city)<=5,city)

measure is - sum(sales)