Timestamp order during load from qvd

[arnould_it]

Hello to all,

Could anyone suggest me how to correctly order records using Timestamp, loading from a qvd?  I've tried in many ways but without success until now.

I've to compare any record with its previous, but to do this the records have to be in ascending order during comparison.

I've also tried ordering records after having loaded them from qvd, using a resident table, but it doesn't work anyway.

This is my timestamp format: 'DD.MM.YYYY hh:mm:ss[.fff]'.

I'm using Qlik Sense.

Thank you in advance for your suggestions

Alessandro

[shraddha_g]

What is the format of data in qvd?

Can you share sample data?

[arnould_it]

This is the original format from a csv file: "04.11.2017 07:00:01"

This is the script set: SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

[arnould_it]

This is a screenshot from the qvd:

it seems ok but when I load it the order sometime changes

[m_s · Accepted solution]

Are you loading your QVD like

LOAD
    *
FROM qvd-file.qvd(qvd)
ORDER BY Timestamp;

and if yes does it still not work?

If so maybe try adding a field containing the numeric timestamp (Num(Timestamp)) and order by that.

Mathias

[arnould_it]

Thanks Mathias,

using (num(timestamp)) it does work.