Help required to sort!

[qlikviewforum]

Hi,

I have Date field which contains the values like 2013-Nov-44, 2013-Nov-45, 2013-Nov-46 and so on. Here 44,45 and 46 are the weeknumber.

Can someone please help me out to sort this.

[sujeetsingh]

Try shorting it by expression and give date field there

[#3]

Hi,

Can i have the expression used to create the Above field.?

reply Soon.

Regards,

Ravikant

[rohitians]

Hey,

Can you upload a sample qvw..

Thanks..

[sujeetsingh]

give me the sample i may try

[qlikviewforum]

Sorry can't attach the qvw

[israrkhan]

Hi,

Try Y-Value Assending.

[qlikviewforum]

No I didn't work out when I sorted it by Y-Value Ascending.

By the way it was working when I sorted it by expression in Ascending order.

left(DateField,4)&''&right(DateField,2).

[dmohanty]

Post some sample data and expression you are using, if not the QVW.

[israrkhan]

thats good try,

but try only right(DateField,2), it will take right two values, as 44, 45, 46, and also try using num like Num(right(DateField,2)), it might help.