topic Store Command in Qlikview in QlikView

Store Command in Qlikview

Thu, 25 Feb 2010 10:20:29 GMT

Actually I am selecting columns frm database .One is a date column(date ant timestamp )

In my store command i want store all columns and the date column(with only date valu) into a qvd

Tab:

sql select

datefinished

...

store Tab into test.qvd;

Can anyone help me out?

Store Command in Qlikview

Thu, 25 Feb 2010 10:30:59 GMT

Hi,

i think you have to CAST date column into Date only not in Datetime while select

e.g

Tab:

sql select

CAST( datefinished as DATE ) as reqired_name,

...

....

It will give only Date format not timestamp.

Hope this will help you

Rahul

Store Command in Qlikview

Thu, 25 Feb 2010 10:34:17 GMT

If I understand what you mean correctly.

Use a where statement and criteria to load only records with a datefinished value.

e.g.

SQL Select *

From XXXDATABASETABLE where "Datefinished" <>'';

Store Command in Qlikview

Thu, 25 Feb 2010 12:01:28 GMT

cast will be useful I thnk.

But

Is there any other way in store command?

Store Command in Qlikview

Miguel_Angel_Baeyens — Thu, 25 Feb 2010 13:33:26 GMT

There is, actually. When you connect in the script dialog to your database, check the "Preceding load" box, so you create a LOAD statement (QlikView "language") where you can format fields. In short, your script should look like this

SourceTable: //Name of table for later reference in QlikViewLOAD Field1, // this can be the same name you are extracting by SELECT statement Field2 AS NewField2, // or renamed for easier understanding Date(Field3) AS Field3; // Date() function of QlikView, not related to datasourceSQL SELECT Field1, Field2, Field3FROM DataSource;

The LOAD clause forces QlikView to do the effort and the job formatting data, so your database performance results less stressed.

This way, you take advantage of speed and memory of QlikView and you just extract information from your database, unconditionally. Even better if you store this file later in a QVD file so processing will be really faster than using your datasource.

Hope this helps.