topic creating QVD file problem in QlikView

creating QVD file problem

Wed, 11 May 2011 13:50:57 GMT

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

creating QVD file problem

ashfaq_haseeb — Wed, 11 May 2011 14:11:03 GMT

while loading use Data(Date_field) as date

in your script to avoid this proble.

hope that helps

Regards

ASHFAQ

creating QVD file problem

Wed, 11 May 2011 14:34:02 GMT

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 ^^