topic Re: sorting in QlikView

sorting

janardhan — Sat, 03 Nov 2012 07:22:36 GMT

Hi Friends ,

I have two columns , like

Hours worksoft.hours

---------------------------------------------------------

orderning35,5 timelon 37,5

orderning37,5 timelon 35,5

I need Output like this :

Hours worksoft.hours

---------------------------------------------------------

orderning35,5 timelon 35,5

orderning37,5 timelon 37,5

Can Anyone help me how to sort

Thanks inAdvace

Janardhanreddy

jagan — Sat, 03 Nov 2012 09:02:15 GMT

Hi Janardhan,

Try this script below

Temp:

LOAD * INLINE [

Hours1,Hours2

"orderning35,5", "timelon 37,5"

"orderning37,5", "timelon 35,5"

];

Test:

LOAD

RowNo() AS RowNo,

Hours1

RESIDENT Temp

ORDER BY Hours1;

Test2:

LOAD

RowNo() AS RowNo,

Hours2

RESIDENT Temp

ORDER BY Hours2;

DROP Table Temp;

Hope this is what you are expecting.

Regards,

Jagan.