topic Re: Help required to sort! in QlikView

Help required to sort!

qlikviewforum — Mon, 18 Nov 2013 07:10:45 GMT

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.

Re: Help required to sort!

sujeetsingh — Mon, 18 Nov 2013 07:24:10 GMT

Try shorting it by expression and give date field there

Re: Help required to sort!

Mon, 18 Nov 2013 07:25:10 GMT

Hi,

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

reply Soon.

Regards,

Ravikant

Re: Help required to sort!

rohitians — Mon, 18 Nov 2013 07:25:34 GMT

Hey,

Can you upload a sample qvw..

Thanks..

Re: Help required to sort!

sujeetsingh — Mon, 18 Nov 2013 07:31:10 GMT

give me the sample i may try

Re: Help required to sort!

qlikviewforum — Mon, 18 Nov 2013 07:33:53 GMT

Sorry can't attach the qvw

Re: Help required to sort!

israrkhan — Mon, 18 Nov 2013 07:36:58 GMT

Hi,

Try Y-Value Assending.

Re: Help required to sort!

qlikviewforum — Mon, 18 Nov 2013 07:49:44 GMT

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).

Re: Help required to sort!

dmohanty — Mon, 18 Nov 2013 07:52:58 GMT

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

Re: Help required to sort!

israrkhan — Mon, 18 Nov 2013 07:57:44 GMT

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.

Re: Help required to sort!

Mon, 18 Nov 2013 08:03:58 GMT

Hi,

Try this sample Script

Raw_Data:

LOAD * Inline

[Sample_Date

2013/11/03

2013/11/06

2013/11/22

];

Data:

LOAD Year ( date# ( Sample_Date, 'YYYY/MM/DD' ) ) As years,

Month ( date# ( Sample_Date,'YYYY/MM/DD' ) ) as months,

Week ( date# ( Sample_Date, 'YYYY/MM/DD' ) ) as weeks

Resident Raw_Data;

Final_Data:

Load Dual ( years & '-' & months & '-' & weeks, weeks ) as Result

Resident Data

Order by weeks;

Drop Tables Raw_Data , Data

Hope It helps You.

Regards,

Ravikant

Re: Help required to sort!

sujeetsingh — Mon, 18 Nov 2013 09:05:29 GMT

See this sample

Re: Help required to sort!

Mon, 18 Nov 2013 09:14:19 GMT

Hi,

Create a Date field in Number format at script level and in SORT tab choose the Expression option call this field in Expression.

Example : currently you are having in this format 2013-Nov-44. please convert into this format 20131144 and then give this field in front end.

for example Date field name is TRANSACTIONDATE please right the below script to convert in number format and store it in new field.

Year(TRANSACTIONDATE)&num(Month(TRANSACTIONDATE ))&Week(TRANSACTIONDATE) As TRANSACTIONDATE _NUM and then call this in front end.

Regards,

Santhosh G