topic qvd with lookup values in App Development https://community.qlik.com/t5/App-Development/qvd-with-lookup-values/m-p/1261390#M25699 <HTML><HEAD></HEAD><BODY><P>I have a fairly large &amp; wide table (~2 million rows) and I have 7 different look up tables for it. I created a qvd which uses apply map to look up all these values so I am storing male/ female instead of 1/2 and so on. Does any one know how will it compare to a qvd which stores 1/2 and joins with look up in my qvf data model? </P></BODY></HTML> Wed, 16 Nov 2016 15:25:57 GMT 2016-11-16T15:25:57Z qvd with lookup values https://community.qlik.com/t5/App-Development/qvd-with-lookup-values/m-p/1261390#M25699 <HTML><HEAD></HEAD><BODY><P>I have a fairly large &amp; wide table (~2 million rows) and I have 7 different look up tables for it. I created a qvd which uses apply map to look up all these values so I am storing male/ female instead of 1/2 and so on. Does any one know how will it compare to a qvd which stores 1/2 and joins with look up in my qvf data model? </P></BODY></HTML> Wed, 16 Nov 2016 15:25:57 GMT https://community.qlik.com/t5/App-Development/qvd-with-lookup-values/m-p/1261390#M25699 2016-11-16T15:25:57Z Re: qvd with lookup values https://community.qlik.com/t5/App-Development/qvd-with-lookup-values/m-p/1261391#M25700 <HTML><HEAD></HEAD><BODY><P>Akshata,</P><P></P><P>The size of the QVDs with and without look up will be pretty close the same, as Qlik implement a clever way to save the data that optimize QVDs size. You can test this concept by saving the QVDs with and without the look up.</P><P></P><P>You data model will be smaller, with less tables in it, that will be benefitial when we are talking about gender and alike, it will be easier to understand.</P><P></P><P>I haven't notice any performance impact, and it could reduce your memory usage as well.</P></BODY></HTML> Thu, 17 Nov 2016 18:14:11 GMT https://community.qlik.com/t5/App-Development/qvd-with-lookup-values/m-p/1261391#M25700 ArnadoSandoval 2016-11-17T18:14:11Z