Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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))
)
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