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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
LisaRaj
Contributor II
Contributor II

Passing multiple values in On Demand App Generation in Qlik Sense Windows Enterprise

I'm trying to pass multiple dates to a template app from a selection app using the Load Script. I've encountered an issue where the MATCH function isn't loading the data as expected.

In my Load Script, I'm fetching values from a QVD and using the following WHERE clause:

WHERE Match(JoinDate, $(odag_JoinDate)) This isn't working.

 However, when I use the equal operator like this:

JoinDate = $(odag_JoinDate) it works perfectly for a single value.

What could be the solution to make the MATCH function work for multiple dates? Any help would be greatly appreciated!

Qlik Sense Enterprise on Windows 

Labels (5)
1 Solution

Accepted Solutions
LisaRaj
Contributor II
Contributor II
Author

Solution is :

WHERE Match(Date(JoinDate,'DD/MM/YYYY'), $(odag_JoinDate)) 

View solution in original post

1 Reply
LisaRaj
Contributor II
Contributor II
Author

Solution is :

WHERE Match(Date(JoinDate,'DD/MM/YYYY'), $(odag_JoinDate))