topic sorting in drilldown in QlikView

sorting in drilldown

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: sorting in drilldown

Anil_Babu_Samineni — Fri, 16 Jun 2017 05:21:40 GMT

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

Re: sorting in drilldown

satishqlik — Fri, 16 Jun 2017 05:25:21 GMT

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

Re: sorting in drilldown

Anil_Babu_Samineni — Fri, 16 Jun 2017 05:26:29 GMT

Will you about to provide qvf?

Re: sorting in drilldown

satishqlik — Fri, 16 Jun 2017 05:33:34 GMT

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???

Re: sorting in drilldown

Anil_Babu_Samineni — Fri, 16 Jun 2017 05:37:04 GMT

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.

Re: sorting in drilldown

satishqlik — Fri, 16 Jun 2017 05:46:32 GMT

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???

Re: sorting in drilldown

Anil_Babu_Samineni — Fri, 16 Jun 2017 05:50:15 GMT

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