Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Date(Date#(Periodo, 'YYYY-MMM'), 'YYYY-MMM')
can you try above format
I Need sorting Order Like 2021-Jan,2020-Jan,2021-Feb,2020-Feb,2021-Mar,2020-Mar,Etc...
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.
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