topic QVD creation efficiency in QlikView

QVD creation efficiency

Anonymous — Wed, 25 May 2011 12:47:28 GMT

I currently use the below 3 step process to create qvd. My guess is that this 3 step process could be improved by something along the lines of 'select .....from.... into file.qvd', which is a single step process. Any thoughts?

Thanks,

Dinesh.

[table_x]:

select column_a

, column_b

from table_x

;

STORE table_x into table_x.qvd;

DROP table table_x;

QVD creation efficiency

nagaiank — Wed, 25 May 2011 13:23:08 GMT

The syntax of 'SELECT' in QlikView script is:

select [ all | distinct | distinctrow | top n [ percent ] ] *fieldlist

from tablelist

[ where criterion ]

[ group by fieldlist [ having criterion ] ]

[ order by fieldlist [ asc | desc ] ]

[ ( inner | left | right | full ) join tablename on fieldref = fieldref

]

It does not include using 'INTO'

QVD creation efficiency

Anonymous — Wed, 25 May 2011 13:25:46 GMT

I know!!! probably more of a gripe from me!! Maybe in the future enhancements !!!