Date Format from QVD Files

[christian_frees]

Hello i'm fighting with data formats in qlik. Normaly i use the german format for reports and loading scripts, but now i need to load data for a qliksense system in us format.

Is there a possibility to see the format of the values in den qvd files?

I want to see the values in these files, to find out if the mistake is in the data extraction and loading strucure from the qvd files or is the mistake in my loading script in the app.

Maybe qliksense does not reconised the data format in the qvd file at the import because it does not fit to the us settings.

Thanks 

Christian

[Oleg_Troyansky]

Hi Christian,

Are you familiar with EasyQlik QVD Viewer?

https://easyqlik.com/qviewer/

It's free to use, and it shows you the data in your QVD files "as is", the way it's stored in the files.

Cheers,

Oleg Troyansky

P.S. Allow me to invite you to my Qlik Expert Class that I'll be teaching in Vienna, Austria on September 22-24. I will be teaching advanced data modeling, along with advanced scripting, performance optimization, and advanced aggregation and Set Analysis techniques. You will learn the most advanced Qlik methodologies that will help you solve tough problems like this one.

[adilio_silva]

If you use Python for analysis, you can use the library below to read the data into a Jupyter Notebook.

https://pypi.org/project/qvd/

If you save the data in Parquet format, you can read it in a variety of ways, such as with in-memory DuckDB, among other methods.

Good luck!

[Kaushik2020]

Easy way i prefer is to load the qvd and add a Table object in the sheet. 

Try to add the date field as a dimension to see the format. 

[marcus_sommer · Accepted solution]

If the date is stored in a german format it needs to be read as such - and re-formatted afterwards. This might be approached with:

t: load date(date#(MyDate, 'DD.MM.YYYY')) as MyDate from X;

or alternatively you may adjust the interpretation-variables - maybe n times within the script, like:

SET DateFormat='DD.MM.YYYY';

or avoiding the most of the format stuff and just keeping all date/times which are used as keys or in calculations/matchings as pure numbers and pulling all the visible fields from an appropriate calendar.