1 Reply Latest reply: Mar 4, 2018 3:11 PM by asier fernandez RSS

    On Demand App Generation Query

    Prasad Mundewadi

      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?