Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

QVD

Hi All,

Help me some one This Query

How could you say QVD is Optimized ? some one as asked this Question

Thanks in Advance

Niranjan 

Labels (1)
11 Replies
Not applicable

Hi Niranjan,

When we load data from any source into Qlikview, the data are compressed in a way of array pointer concept.

Ex:- In a table we have 2 fields and 10 rows.

F1F2
A110
B120
A230
B240
A150
A260
B170
A180

While loading into Qlikview it consider the above data as given below.

Considering the value A1 once and identifying the occurence of the value in the form of pointer. Physically A1 is appearing once and the count of occurence is 3. By doing this the amount of space is less and hence the data are compressed.

Hope this helps!

--

Vinoth

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Niru Niru.

Have a look at this article on Optimisation. It may help you.

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Regards,

Neil