Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
https://community.qlik.com/message/197287#197287 |
Hi All
I currently get a qlikview document to work by running the SQL, then creating a QVD file. I want to sore the QVD file according to Person ID. (Currently I make it an Excel file and sort it according to personID)
Directory;
LOAD
PersonID,
dateCT,
dateQA
FROM
[Table3.qvd]
(qvd)
//ORDER BY PersonID, dateCT
;
The sql that I run to get the table sorted is shown below - then I copy this into an Excel file:
SELECT *
FROM vw_tableOfDates
ORDER BY PersonID, dateCT
;
Is there an easier way of doing this? Order by does not work in QlikView?
Thank you for any help.
Jo
Order By works in QlikView. It is just that you have to use it with Resident load. Try like:
Temp:
LOAD
PersonID,
dateCT,
dateQA
FROM
[Table3.qvd]
(qvd);
NoConcatenate
Fina:
LOAD
PersonID,
dateCT,
dateQA
Resident Temp ORDER BY PersonID, dateCT ;
Drop table Temp;
Order By works in QlikView. It is just that you have to use it with Resident load. Try like:
Temp:
LOAD
PersonID,
dateCT,
dateQA
FROM
[Table3.qvd]
(qvd);
NoConcatenate
Fina:
LOAD
PersonID,
dateCT,
dateQA
Resident Temp ORDER BY PersonID, dateCT ;
Drop table Temp;
ok ... sort of
if I have a calculated field that depends on Previous function - I would need to use it in the Fina table load?
Jo
Yes.
It worked - thank you! thank you!
Jo