On Demand App Generation Query

[prasadmundewadi]

Hi All

I am trying to learn ODAG in Qlik sense. created a simple selection app and a simple template app. Here is my code in the the template app:

[Opty History]:

LOAD

[PRIMARY_KEY],

[ID],

[ACCOUNTID],

[NAME],

[STAGENAME],

[AMOUNT]

FROM [lib://Everyone/Extract QVDs\EDW_WC_PTC_OPTY_CHG_F.qvd](qvd)

where [ACCOUNTID] = $(od_ACCOUNTID);

Now when I hit generate app it generates the app but adds additional chr(39) to my code like this:

[Opty History]:

LOAD

[PRIMARY_KEY],

[QLIK_MODIFIED_DATE],

[ID],

[ISDELETED],

[ACCOUNTID],

[NAME],

[STAGENAME],

[AMOUNT]

FROM [lib://Everyone/Extract QVDs\EDW_WC_PTC_OPTY_CHG_F.qvd](qvd)

where [ACCOUNTID] = chr(39) & '001F000000mbCWrIAM' & chr(39);

Because of this my app is returning no results. What am i doing wrong? Can somebody help?

[Asier_Fernandez · Accepted solution]

Hi Prasad

Check the following link as it explains how to solve it;

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/bind-expressions-OnDe...

Bests.