topic Re: Sorting in a bar chart in QlikView

Sorting in a bar chart

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

Hi,

I have created a bar chart which is showing data by Teams. I also created a drill down group (team, year, month). I have used it in dimension and now when i click on any team it takes me to month -wise view but it is not sorted Jan-Dec but they are coming in order of their load(which i think).

can anyone please help me to solve this.?

Thanks

Sagar

Re: Sorting in a bar chart

adamdavi3s — Wed, 08 Feb 2017 12:06:18 GMT

Hi Sagar,

You need to change the sort on the sort tab, if you have month number do something like this in the sort expression for month name

=only({1}MonthNo)

Re: Sorting in a bar chart

sdmech81 — Wed, 08 Feb 2017 12:19:14 GMT

Hi,

Please share the application.Hope your month order is not frm Jan -dec.

Re: Sorting in a bar chart

sdmech81 — Wed, 08 Feb 2017 12:33:23 GMT

You need to order by your data inside the script based on date_Key

Then say in bar graph sort tab as sort by load order.

Hope this helps