Sorting Bar Chart

Arnec — Sat, 16 Nov 2024 01:15:11 GMT

I've created a bar chart with clustered columns but can't quite find the way to sort them correctly. I'm currently showing data for the turnover of the last 5 years per country. I sort on the turnover of this year. However I have the possibility to filter on Year, Month, Day, Country, Customer group, ... and so on and this seems to work but the sorting won't follow. I've tried several options by trying to calculate the maximum item selected in year and so on, but I can't get to the result.

In the end I would want this bar chart always to sort descending.

I have the following set up:

Dimension

CountryName

Expression(s) - I have 4 in total in which the 0 below changes from 0 to -4 the get 5 clustered columns. I'm currently also using the expression below to sort (which I know is wrong)

=if(Match(GetFieldSelections(_verSelection), 'Turnover'),
sum(if (InYear (DocDate, today(), 0), Turnover))
,
sum(if (InYear (DocDate, today(), 0), Turnover - Cost))
)

Re: Sorting Bar Chart

Brett_Bleess — Tue, 24 Mar 2020 18:55:14 GMT

For these types of posts, it is most helpful if you can attach an example QVW file, so folks can look into the data model, expressions and chart properties to try to sort out why things are not working properly, bit difficult to help otherwise. The best alternative I have would be the Help to see if you can find something specific there to the sorting in that chart type, or you can check the Design Blog area for ideas/examples to see if you can find something to help there:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm

Sorry I do not have anything better.

Regards,
Brett

topic Sorting Bar Chart in QlikView

Sorting Bar Chart

Re: Sorting Bar Chart