Qliksense - Passing Variables with multiple values into QVD Data load
I have developed a series of QVD's to load bulk into Qliksense (much faster than querying SQl directly) I am now creating a series Apps that will pull sections of this data into visualisations.
As I don't want to have load the entire data set into each app I have added a where into the data load editor. I have than a variable to allow me to duplicate the app ( as the core design is the same across the various deprtments) across all streams and then just amend the value in the where clause (that how the client wants it done, each department has there own stream with app within).
While I can set a variable with one value and pass into the load, in the where clause, easily I can't seem to get the syntax to pass in a multi value parameter.
set vcode = ('nigel','bob')
loaddata:
LOAD
*
from another.qvd (qvd)
where match(name,'$(vcode)')
It doesn't error out just returns no value.
I have tested using where match(name,'nigel','bob') so I know that it can pull data.
Using a variable will be easier to maintain and update and will cleaner.
Cheers the reply, I have tried 'Nigel','bob' and it still returns 0 lines. I am wrapping the variable in a match and also tried as a name = and both times it is returning 0. It doesn't appear to work in the same way an IN SQL statement does. When I use just one it works fine. Is there some snytax I am missing for Qlik to realise it is actual 2 values and treat it in the same way SQL handles an IN statement.
