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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD Database Filter

Dear Experts,

I have more than one QVD and I want to filter the particular database in the same QVD in Load * from QVD statement.

I don't want to generate the second QVD after filtering.

Please suggest the same.

Thanks and Regards@

Amol Khochare

1 Reply
tresesco
MVP
MVP

Are you trying to reduce a QVD? If so, you can do that simply by overwritting it, like:

Temp:

Load

          *

From <qvdpath> QVD1.qvd(qvd) Where <your condition>;

Store Temp Into <qvdpath>QVD1.qvd(qvd);