topic Re: concatenate year and month Sorting issue in QlikView

concatenate year and month Sorting issue

niranjan_capgemnini — Sat, 16 Nov 2024 04:37:15 GMT

Hi experts,

i am trying to do sorting after concatenating the year and month field in the bar chart but it is not sorting properly.

In the dimension i have used below field
num(Year)&num(Month)

In sorting column i have used below one

num(Year)&num(Month)

it is sorting only 1 to 9 months for all years(2017,2018,2016) but 10 to 12 months showing last .

please give any suggestion.

sunny_talwar — Wed, 30 Jan 2019 13:04:30 GMT

How about if you create your dimension like this

(Year * 100) + Month

and then sort nuemerically

niranjan_capgemnini — Wed, 30 Jan 2019 13:14:52 GMT

Hi Sunny_talwar,

Thank you very much for giving suggestion... it is working fine for me...