topic Re: Re: what are the functions we can use in optimized qvd and non optimized qvd? in QlikView

what are the functions we can use in optimized qvd and non optimized qvd?

Thu, 29 May 2014 04:32:02 GMT

what are the functions we can use in optimized qvd and non optimized qvd? urgent pls

Re: what are the functions we can use in optimized qvd and non optimized qvd?

Thu, 29 May 2014 04:47:58 GMT

Optimized qvd means it doesn't contain any filtering conditions, and in non ptimized qvd load you can use any filtering conditions like where, groupby etc..

Ananth

Re: what are the functions we can use in optimized qvd and non optimized qvd?

Anonymous — Thu, 29 May 2014 04:49:41 GMT

If you are using no functions or any where condition then only your load will be optimized otherwise it will be unoptimized.

Re: Re: what are the functions we can use in optimized qvd and non optimized qvd?

rwunderlich — Thu, 29 May 2014 04:54:45 GMT

Here's a list that as far as I know is current..

1)F1 as newfield - yes, rename allowed

2)F1 * 2 as newfield – no, transformation

3)1 as newfield – no, cannot add new field

4)where exists(F1) – yes, single field exists()

5)where exists(F1, F3) – no, multi-field exists()

6)F1 as newfield where exists(F1) - no

Re: what are the functions we can use in optimized qvd and non optimized qvd?

Thu, 29 May 2014 05:02:33 GMT

Thanks for your clarification Rob......!

Ananth

Re: what are the functions we can use in optimized qvd and non optimized qvd?

Thu, 29 May 2014 05:22:40 GMT

ante brother optimized lo emi functions use cheyalema ? only poosible in non optimized qvd avi like where, group by

Re: what are the functions we can use in optimized qvd and non optimized qvd?

jagan — Thu, 29 May 2014 05:39:59 GMT

Hi Manoj,

There is no concept of Optimized and Non Optimized QVDs. There is only Optimized and Non Optiminzed QVD loading. There are no functions to make optimized qvd loading, if you are doing any transformations or filtering then it is not optimized QVD loading, but still it is faster than loading from database.

For example:

DATA:

LOAD

FROM DataSource; -- Is an optimized load, since we are not doing any transformations

DATA:

LOAD

Field1 * Field2 AS NewField

FROM DataSource; -- This is not an optimized load, since we are deriving a new field from existing fields

Refer Robs post above for Optimized and Non Optimized loading scenarios.

Regards,

Jagan.

Re: what are the functions we can use in optimized qvd and non optimized qvd?

jagan — Thu, 29 May 2014 05:42:06 GMT

Hi Manoj,

Please find below explanation from Qlikview help file.

A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only be written to and read by QlikView. The file format is optimized for speed when reading data from a QlikView script but it is still very compact. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.

QVD files can be read in two modes: standard (fast) and optimized (faster). The selected mode is determined automatically by the QlikView script engine. Optimized mode can be utilized only when all loaded fields are read without any transformations (formulas acting upon the fields), though the renaming of fields is allowed. A WHERE clause causing QlikView to unpack the records will also disable the optimized load.

Regards,

Jagan.