Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
satishqlik
Creator II
Creator II

sorting in drilldown

Hi,

In Qliksense,

I have created bar chart with drilldown(Month and department) for employees count.

If I select April on chart all the department wise employee count is coming but not in sorting order.

If I want to give the sorting order to drilldown, how to accomplish this requirement.??

7 Replies
Anil_Babu_Samineni

Can you make Sort auto for Month from sorting pane. And let us know

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
satishqlik
Creator II
Creator II
Author

I tried the same but I want to show by department.

Anil_Babu_Samineni

Will you about to provide qvf?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
satishqlik
Creator II
Creator II
Author

am not able to share my qvf  rightnow as am using my real data.

That would be great if you can suggest me on this.

how do I give sorting order to department???

Anil_Babu_Samineni

Don't require to share real data over community, As always we will expect only dummy data for mock. Anyhow, Now tell me How many dimensions you used over object and would be nice if you provide screen shots where it's not sorting.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
satishqlik
Creator II
Creator II
Author

Hi,

Thanks anil for your quik response.

In Qliksense,

Actually I have created stacked bar chart with dimensions Month and Department 

expression count(empnum)

If I select Month Apr in chart that is showing department wise emp count but not in sorting order

how do we achieve this???

Anil_Babu_Samineni

Will you able to provide screenshot atleast? In fact, this is tough to analyze

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful