Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Bujarski
Contributor II
Contributor II

ODAG filters not able to pass multiple selections

Qlik Sense November 2021

Background:  I have been successful in creating a  dynamic data store of thousands of QVD's (with some help from this form!).

Requirement is to be able to now odag to these numerous QVD's, however,  it's only working for an individual filter selection from the selector app,  e.g.  Period 202301 works,  but 202301, 202302 does not.  

Error:  Unexpected token: ',', expected one of: 'OPERATOR_PLUS'...'Like",'and' etc....

Target Code/syntax;

Set odag_Field1 = '';
Set odag_Field2 = '';
Set odag_Field3 = '';
END IF;

Let vQVDName = 'Text_'&$(odag_Field1)&'_'&$(odag_Field2)&'_'&$(odag_Field3)&'.qvd';
Trace $(vQVDName);
Load *
FROM [PATH/Text_/$(vQVDName)] (qvd);

How can I get this to select/pull the data from multiple qvds, if possible?

I've tried changing '=' to IN; Like; OR but no luck

Bujarski_1-1687442497006.png

 

 

 

 

 

 

Labels (1)
0 Replies