Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Sort

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 .

smilingjohn_0-1640273981683.png

 

 

Thanks in Advance 

7 Replies
smilingjohn
Specialist
Specialist
Author

Hi Community,

Any help on my above post ?

 

anat
Specialist II
Specialist II

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

smilingjohn
Specialist
Specialist
Author

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

anat
Specialist II
Specialist II

load *,monthname(datefield) as MN;

use MN field in chart like sort by expression

smilingjohn
Specialist
Specialist
Author

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 

smilingjohn_0-1640274096116.png

 

 

Thanks

smilingjohn
Specialist
Specialist
Author

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

anat
Specialist II
Specialist II

@smilingjohn ,

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