Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshmanudui
Contributor II
Contributor II

How to do sorting in text box Qlikview

Hi All,

I have Month field, I am able to sort the data in list box, But in text box I can't sort the month field.

My requirement is in text box showing Month field information like Jan, Feb, Mar, similar to that .

Currently I am able to see the data in alphabet order

Could any one suggest me how to arrange calendar order in text box.

Thanks & Regards,

Lakshman

Labels (1)
1 Reply
eddie_wagt
Partner - Creator III
Partner - Creator III

I assume you are using the function concat. Anyway, I use it as an example below.

 

concat(distinct Month,',',Month_sort)

 

As you can see, you can add a sort weight to this function. You only need a sortingfield in your data. 

 

LOAD RowNo() as Month_sort
,	 Month
;
LOAD * INLINE [Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec];

 

 

Kind regards

Eddie

If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply.