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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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))