Qlik Sense On Demand App Generation load progress error

[micklesj]

Hello!  I'm getting an error when hitting the generate new app button using the navigation link.  I have the detail template app created, and the selection high level app created, with the navigation link set up, it's generating the template app but not recognizing the selections made and also throws an error " Reload error : (Connector error:  ERROR [42000] SQL Compilation error:  syntax error line 61 at position 0 unexpected 'AND'.).

I know it has something to do with my sql in the detail template app but am having no luck fixing it.  Attached is a document with screenshots of everything.  I'm sooooo close to getting this working, please help!  I truly appreciate it.  Thank you in advance!

[Michael_Tarallo]

Hi Jessica - please wrap the $ variables in single quotes and let me know

[micklesj]

Hi Mike!

That seems to have worked but now I'm getting this error:

I'll keep at it!  I really appreciate you taking the time to help me! 

[micklesj · Accepted solution]

Hello everyone,

The way that we got this to work was:

1)  create detail template app and in the data load editor put the following in with the query:

Let vPostDate = $(od_POSTING_DT);
Let vBranchName = $(od_ACCOUNT_ASSIGNED_BRANCH_COST_CENTER_NM);
Let vRegion = $(od_RETAIL_REGION_CD);

blah blah blah...

WHERE 1=1
AND POSTING_DT In ($(vPostDate))
AND ACCOUNT_ASSIGNED_BRANCH_COST_CENTER_NM In ($(vBranchName))
AND RETAIL_REGION_CD In ($(vRegion))

2)  create the high level selection app and use the navigation link to create the "odag" button that generates the on demand app etc

Thank you Mike!  Hope this helps someone/anyone out there!

[Michael_Tarallo]

awesome!