Qliksense Bar Chart sorting

[RobinHood]

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

[Kashyap_R · Accepted solution]

Hi

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

[RobinHood]

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

[Kashyap_R · Accepted solution]

Hi

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

[RobinHood]

Exactly the solution I was looking for, many thanks