Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Prasad
Check the following link as it explains how to solve it;
Bests.
Hi Prasad
Check the following link as it explains how to solve it;
Bests.