Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in Qvd now I want to load that data into my report using data load editor so I want to sort this data in data load editor using timestamp
Timestamp format : 2023-08-14 14:14:26.020000
Try it with:
t1: load * from qvd;
t2: noconcatenate load * resident t1 order by timestamp;
drop tables t1;
Not working not sure why
What happens? Any error or unexpected results? Did you apply the suggestion closely or with any adaption? Means you should share some more details, like a few input- and output-records - with the current and the expected results as well as the relevant script-parts.
Here I have data like this in qvd
Po , req_type , req_timestamp
1 ,change , 08-08-23 09.20.40.450000 AM
1, create ,08-08-23 09.18.20.100000 AM
So I am contacting those req_types based on po
Po , re_type
1, create,change
Here create should be first as it is created first you can observe this in timestamp
It should work as described above if the timestamp is really a timestamp which means it's a numeric value with a formatting. Further you will probably need to include other key-fields within the order by statement.
If the timestamp-field is instead a string you will to convert it to a timestamp per timestamp#(Field, Format). The specified format-patter must absolutely identically to the data. You may need some attempts to find the right ones. Helpful might be also to cut the string and convert the single parts and adding them again. All this should be already applied in the script which creates the qvd and maybe even the sorting might be done there.
No , while concatenating the distinct req_types Qlik by default sorting this re_type that's i am getting change first then create second is there any way to avoid this
Timestamp is perfect timestamp
Concat() has a third numeric parameter which will sort the result - and here you could apply the timestamp.