Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

creating QVD file problem

hello Community

I'm sort of new in QV.

I created qvd file from db. Using this sample script:

table_name:

load * ;

sql select *

from .....

     store table_name into 'table_name.qvd';

after this don't know why after my date field some zeroes added. example 20110511.00 like this. also some fields looks like date is got this zeroes. In database date format is fine. Can anybody tell mi how to solve this. And please explain why?

Kind regards

Muncho

1 Solution

Accepted Solutions

creating QVD file problem

Hi

while loading use Data(Date_field) as date

in your script to avoid this proble.

hope that helps

Regards

ASHFAQ

2 Replies

creating QVD file problem

Hi

while loading use Data(Date_field) as date

in your script to avoid this proble.

hope that helps

Regards

ASHFAQ

Not applicable

creating QVD file problem

Hi ASHFAQ

Thanks for date() xD.

I thought date_field date format fine in our DB. But it was not. I used date#() and now its fine.

that was easy as pie ^^

Community Browser