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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-09-23 02:05 AM

Regarding QVD optimization

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.

456 Views
0 Likes
2 Replies
arulsettu
Master III
Master III
‎2014-09-23 02:18 AM

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)

366 Views
Colin-Albert
Partner - Champion
Partner - Champion
‎2014-09-23 03:03 AM

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

366 Views