Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help me in sorting the data in straight table?

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 IDDate
A12322/1/2016
A34210/2/2016
B98315/2/2016
C11111/2/2016
C25614/1/2016
D12311/2/2016
D1405/3/2016
A23428/1/2016
A54315/1/2016
C2349/3/2016
D11213/1/2016
B34221/1/2016
Expected Output
Customer IDDate
A54315/1/2016
A12322/1/2016
A23428/1/2016
A34210/2/2016
B34221/1/2016
B98315/2/2016
C25614/1/2016
C11111/2/2016
C2349/3/2016
D11213/1/2016
D12311/2/2016
D1405/3/2016
8 Replies
Chanty4u
Champion III
Champion III

Chanty4u
Champion III
Champion III

u can use FirstSortedValue

Not applicable
Author

how to use first sorted value for customer and date?

amayuresh
Creator III
Creator III

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

balrajahlawat
Champion
Champion

post a sample file?

settu_periasamy

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

Not applicable
Author

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.

sunny_talwar

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)

Capture.PNG