Discussion Board for collaboration related to QlikView App Development.
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
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
UK
];
Data:
LOAD *
FROM [your qvd]
WHERE EXISTS (Country)
;
Optimised