Sorting Month-Year Wise in Bar Chart - Qlik Community

sathishraja510 · ‎2022-01-24

Hi,

i need below-attached sample like sorting in the bar chart.

All Jan month First then Feb,MAr,Apr etc...

Anyone helps it's very urgent.

Thanks in Advance.

anat · ‎2022-01-24

Date(Date#(Periodo, 'YYYY-MMM'), 'YYYY-MMM')

can you try above format

sathishraja510 · ‎2022-01-24

I Need sorting Order Like 2021-Jan,2020-Jan,2021-Feb,2020-Feb,2021-Mar,2020-Mar,Etc...

chris_djih · ‎2022-01-25

There are several possible solutions, depending on what you want with the field later on.
The most simple variant is using a dual:

Dual(Month(datefield)&'-'&Year(datefield),Year(datefield)*100+Month(datefield))

This options is the most easiest that work. But you can't use this as a field if you want to make explizit date calculations. But maybe this holds already for your problem.

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.

vikasmahajan · ‎2022-01-27

Hi,

Refer this

https://community.qlik.com/t5/QlikView-App-Dev/Sort-Month-Name/m-p/836194

make sure you have monthnum field in calendar.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.