How to sort a field that is a mix of number and text ??

[#1]

'Q' & Ceil(Month(Start_Month)/3) & '-' & Yearname(Start_Month) as Quarter_IPC

The above is my definition of a variable.

It shows up as:

Q4-1990

Q3-1992

Q1-1995

...

...

...

How can I sort these year wise ? Like

Q1-1990

Q2-1990

Q3-1990

Q4-1990

Q1-1991

..

..

[#2]

Hi,

In the list box property, go to Sort tab, tick Expression check box and use the expression as "=Start_Month"

[er_mohit]

try in sort tab expression

dual(Quarter_IPC,Year(Start_Month))

in ascending order

[#4]

Nope. Its not working.

There is also that red line appearing beneath the text when I enter it in that expression box.

"=Start_Month"

[CELAMBARASAN · Accepted solution]

Create a field with Dual

Dual('Q' & Ceil(Month(Start_Month)/3) & '-' & Year(Start_Month), QuarterStart(Start_Month)) as Quarter_IPC

Then Use Sort By Number as ascending

[#6]

This also is unfortunately not working !

[jagan]

Hi,

Try like this

Dual('Q' & Ceil(Month(Start_Month)/3) & '-' & Yearname(Start_Month), QuarterSTart(Start_Month)) as Quarter_IPC

Now in Chart Properties -> Sort tab ->  select Numeric Value

Hope this helps you.

Regards,

Jagan.

[#8]

Thanx Adhimulam!

Marked as right option - Here goes your incentive !

[#9]

Thanks dude.