Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a month field...that is not in a sort order...but ,i want to make it in proper sort order.
can anyone tel me!!!
PFA file
Regards,
Smiley.
this is alphabetical order
do you have a datefield?
if yes, goto sort tab and enter month(yourdatefield) in ascending order
i can think of two options.
1) in your script, when you are loading the month name use the dual function to add a number to the month name that way you will have for each month the proper month number, for example Jan will have 1 and March will have 3.
then in your chart go to sort tab and sort using numeric asc or desc.
2) go to sort tab in your chart, and under expression sort them using the match function:
match(Month,'Jan','Feb','Mar' ...)
Hi
You can try these way:
Create a field in script by using
Num(Month(DateField)) as MonthNum;
Sort tab:
Expression : MonthNum
or
Sort:
Load Order: Ascending
If ur data is load in ascending order like Jan, Feb,....
or
Expression: match(Month,'Jan','Feb','Mar' ...)
Hi Rudolf,
Thanks for your reply!!
The field MO_SHRT_NM is contains the values as Aug,Sep,Mar,...Dec.
this field i am using as dimention in a combo chart...there i am facing the sorting issue.
Regards,
Smiley.
without knowing more about your app, i would suggest
to use an inline table with
[MO_SHRT_NM, sortnr
Jan, 1
Feb, 2
..
Dec, 12]
which connects to your MO_SHRT_NM and you can use sortnr in the sortfield
Go to Sort Tab....
Expression
Write below
Date#(MO_SHRT_NM,'MMM')
Hi,
Try below for sorting
Dual("Your Month Field",match("Your Month Field" ,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))
Regards
ASHFAQ
in list box properties, sort it according to expression, i mean in formatting write the mmm/yyyy format for sorting. so sorting will happen based on the expression written for sort.
Hi Malek,
canu please give me some example how to use dual function in this situation.
Regards,
Smiley.