sorting the list box values

[Anonymous]

Hi,

                                                                                          

I have the year list box with the above year and Quarter format. now I need the sorting values of Quarter wise year i.e

Suggest me on the same

[sujeetsingh]

Use num as well as text too

[Anonymous]

On the Sort tab of the List Box make sure <Text> is ticked and nothing else.

[sujeetsingh]

See this screen shot

[Anonymous]

Hi,

Sort by "Text" should work. You can find this option in list box properties.

[Anonymous]

Suggest me out

[Anonymous]

See attached qvw that works.

[MK_QSL]

Go to Sort Tab of your List Box

Untick everything

Tick Expression and write below in your Expression

=TRIM(PurgeChar(Year,'Q'))