topic Optimization techiniques in QlikView

Optimization techiniques

Hareeshkommineni — Wed, 25 Nov 2020 16:16:04 GMT

I have data from 4 countrys i want take only one country data without doing any transformations

if we are using where function it can be the unoptimization that why i want to take only one country data with using transformations

it is possible or not?

advance thanks

harish

Re: Optimization techiniques

marcus_malinow — Wed, 13 Feb 2019 13:11:08 GMT

You're correct in that normally using a where clause will break QVD optimisation. There is one exception to this though, which you could take advantage of here. This is when you use the EXISTS function.

In your case, you could load a simple inline table containing just the Name / ID of the country you want to load, then use EXISTS on your existing load.

For example:

tmpCountry:

LOAD * INLINE [

Country

];

Data:

LOAD *

FROM [your qvd]

WHERE EXISTS (Country)

;

Re: Optimization techiniques

Hareeshkommineni — Wed, 13 Feb 2019 13:17:58 GMT

if we are use where exists () it is optimized or unoptimized?

Re: Optimization techiniques

marcus_malinow — Wed, 13 Feb 2019 13:18:33 GMT

Optimised