topic Re: Please help me in sorting the data in straight table? in QlikView

Please help me in sorting the data in straight table?

Thu, 10 Mar 2016 06:47:57 GMT

Hi All,

I need to sort by customer number as well as date in my straight table, already i tried sort option for both, they are sorting only customer number not the date.

I tried order by at backend which is also not working please advice me how to sort the data?

Actual Data
Customer ID	Date
A123	22/1/2016
A342	10/2/2016
B983	15/2/2016
C111	11/2/2016
C256	14/1/2016
D123	11/2/2016
D140	5/3/2016
A234	28/1/2016
A543	15/1/2016
C234	9/3/2016
D112	13/1/2016
B342	21/1/2016
Expected Output
Customer ID	Date
A543	15/1/2016
A123	22/1/2016
A234	28/1/2016
A342	10/2/2016
B342	21/1/2016
B983	15/2/2016
C256	14/1/2016
C111	11/2/2016
C234	9/3/2016
D112	13/1/2016
D123	11/2/2016
D140	5/3/2016

Re: Please help me in sorting the data in straight table?

Chanty4u — Thu, 10 Mar 2016 09:00:29 GMT

chk dis

Rowno & interactive sorting in straight / pivot table

Re: Please help me in sorting the data in straight table?

Chanty4u — Thu, 10 Mar 2016 09:01:36 GMT

u can use FirstSortedValue

Re: Please help me in sorting the data in straight table?

Thu, 10 Mar 2016 09:16:10 GMT

how to use first sorted value for customer and date?

Re: Please help me in sorting the data in straight table?

amayuresh — Thu, 10 Mar 2016 10:03:05 GMT

Try these steps,

1. Select Date field in sort tab

2. choose Frequency option and deselect other option

3. Click Apply

4. Deselect Frequency option

5. Select Text option with A -> Z

6. Click Apply and ok

Re: Please help me in sorting the data in straight table?

Anonymous — Thu, 10 Mar 2016 10:12:02 GMT

post a sample file?

Re: Please help me in sorting the data in straight table?

settu_periasamy — Thu, 10 Mar 2016 10:22:58 GMT

Hi John,

May be check the attachment..

I created dummy calculated dimension like : =Left([Customer ID],1)&Date

Then you can do the normal sort : Text (A-Z) , Numeric value (Ascending)

and Uncheck the 'Allow Interactive Chart'

I think, you can do the same via Aggregation also..

Re: Please help me in sorting the data in straight table?

Thu, 10 Mar 2016 10:29:02 GMT

Hi,

Did you check that the date being populated is in proper Date format?

If not convert into proper date format using date(date#(Date,'DD/MM/YYYY')) at backend and try sorting.

If even that does'nt work trying converting the Date field to Number num(Date) and try.

Regards,

Reshma.

Re: Please help me in sorting the data in straight table?

sunny_talwar — Thu, 10 Mar 2016 10:32:53 GMT

Stealing Settu's idea (and I hope he will have no problem from me doing that ) and made some alternation to come up with an alternative. Instead of using Customer ID as dimension, use a calculated dimension -> =Dual([Customer ID], Ord(Left([Customer ID], 1)) * 100000 + Date)