Sort

[smilingjohn]

Hi All,

How can i make the sort order properly by month which should be like (Aug,Sep,Oct,Nov,Dec)

In qlikview we had the option to sort by expression under sort , but qlkisense is not working as desire .is there any option to bring the sort order in proper order .

Thanks in Advance 

[smilingjohn]

Hi Community,

Any help on my above post ?

[anat]

can u create field using monthname(date) then use this one for sort

[smilingjohn]

I did not get you , could you please elaborate more ? 

[anat]

load *,monthname(datefield) as MN;

use MN field in chart like sort by expression

[smilingjohn]

Hi Community, 

I tried all the option i was aware of but this is not working is a sort order ( From AUG to DEC).

But I am not able to achieve the sort order as desired it gives me the random order of bar chart as shown in the image 

Thanks

[smilingjohn]

 have given up on this as tried all the option but this doesn't work  

[anat]

@smilingjohn ,

if possible can u share your data so that it is easy to work on your problem