topic Re: Sorting Month-Year Wise in Bar Chart in App Development

Sorting Month-Year Wise in Bar Chart

sathishraja510 — Tue, 25 Jan 2022 03:31:49 GMT

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.

Re: Sorting Month-Year Wise in Bar Chart

anat — Tue, 25 Jan 2022 04:36:28 GMT

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

can you try above format

Re: Sorting Month-Year Wise in Bar Chart

sathishraja510 — Tue, 25 Jan 2022 04:52:29 GMT

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

Re: Sorting Month-Year Wise in Bar Chart

chris_djih — Tue, 25 Jan 2022 07:06:43 GMT

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.

Re: Sorting Month-Year Wise in Bar Chart

vikasmahajan — Thu, 27 Jan 2022 12:07:40 GMT

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