topic Qliksense Bar Chart sorting in App Development

Qliksense Bar Chart sorting

RobinHood — Sat, 16 Nov 2024 03:21:37 GMT

Hi,

I want to sort month in Barchart as follows:

suppose current month is Feb2020 and we have to show last 2 years data in Qliksense bar chart

then our bar chart x axis should be sorted as follows :

feb-2020 feb-2019 jan 2020 jan- 2019 dec-2019 dec-2018......

Please help .

Regards,
himanshu

Re: Qliksense Bar Chart sorting

Kashyap_R — Wed, 05 Feb 2020 07:13:31 GMT

If you are using YearMonth directly from the date go through the attached Image

but if you are using the expression in dimension as below

Year(Date) &' - '&Month(Date)

then

In the sorting Bring the Dimension to first

Dimension >> Unselect custom >> Select sort by expression

In expression give Max(Date)

Hope this helps

Thanks

Re: Qliksense Bar Chart sorting

RobinHood — Wed, 05 Feb 2020 07:38:39 GMT

I am afraid if you have got my requirement, I think this wont solve my case as it will give results like feb-2020,jan2020...like that,,,but I need it like this....feb 2020 feb 2019 jan 2020 jan 2019

Re: Qliksense Bar Chart sorting

Kashyap_R — Wed, 05 Feb 2020 10:35:31 GMT

Sorry, I didn't get that requirement earlier.

Please go through the attached file and let me know it's working or not

Hope this helps

Thanks

Re: Qliksense Bar Chart sorting

RobinHood — Wed, 25 Mar 2020 07:04:03 GMT

Exactly the solution I was looking for, many thanks