Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Using a Separate File to Control Filtering

Hi All,

I have created a QVD which is to be used by a series of end user's who at times will need to apply Where Clauses for 20+ values on a particular ID field.  I am trying to think of a way to allow them to do this without writing out a long Where (MATCH,ID,'1',....'20').  My initial idea was at the same time the QVD is created I created a CSV file with all values for the ID field and 'N' as Include.  See below


Load *
Resident test;

Drop table test;

Store Export [file.qvd] (qvd);

Load Distinct


'N' as Include

Resident Export;

Drop table Export;

Store ID_Filters into [file.csv] (txt);

This would allow End User to open the CSV file and for the ID's they want to include set the value to Y then when loading the QVD they would do.


Load *
From File.qvd(qvd);

Inner Join(Table1)

Load *
From file.csv

Where Include  = 'Y';

The problem I am having is when I open the csv file in Exel and make any changes then save the CSV file it becomes one column.

Does anyone have any other ideas of how to accomplish what I am trying to do?


1 Reply
Creator III
Creator III

I seem to have found a work around solution.  I found a macro script here which allows for quick conversion of CSV files to XLSX files here Excel VBA convert CSV to Excel