topic Year-Month not sorting correctly in Combo chart in App Development

Year-Month not sorting correctly in Combo chart

qlikbbguser — Tue, 20 Aug 2024 19:25:20 GMT

hello,

I created a combo chart with two measures and 1 dimension. The dimension/X axis is in format of "YYYY-MMM (example: 2023-Dec) ".

I would like to sort the X axis from oldest to newest date but can't figure out how. Any insights? In a line or bar chart where there is only one measure, the date sorting seems to be working fine.

Thanks!

Re: Year-Month not sorting correctly in Combo chart

gomeri — Wed, 21 Aug 2024 11:52:13 GMT

Hi,

can you try to trasform your dimension in:

=Date#(NameDimension, 'YYYY-MMM')

Thanks

Re: Year-Month not sorting correctly in Combo chart

Padma123 — Wed, 21 Aug 2024 12:37:34 GMT

Hi,

It is not possible when the combo chart having 2 measure(it is possible only 1 measure is present )