Regarding QVD optimization

[#1]

Hi all,

I have a requirement regarding qlikview optimization in qvds. Assume there is excel file with 1lakh records out of which 25000 are duplicates, now consider I am creating a qvd file for this excel.

My requirement is before creating the qvd can we give notify the developer of having redundant data in the excel file.I heard that there is a mechanism know as notify ,but I am unaware of it. Can anybody let me know.

Thank You.

[arulsettu]

hi

you can give WHERE EXISTS while creating qvd it will allow only exists value so you can avoid the nulls

EX:

WHERE EXISTS(field name)

[Colin-Albert]

You can use a WHERE NOT EXISTS (KEYFIELD) to prevent duplicates being loaded.