5 Replies Latest reply: Apr 8, 2013 3:25 PM by Mike Moraski RSS

    Store inputfield in QVD

    Mike Moraski

      I have been using Qlikview for only a few months so bare with me if this is a simple question: I have a Collections Dashboard in which I want to allow the user to track each time they contact a customer by entering in a date and a note using the inputfield script. I understand that inputfield only stores this information at the user level, but I am trying to permanently store the ContactDate and ContactNotes inputfield information in a QVD. Below is my script; any and all feedback would help!

       

      INPUTFIELD ContactDate,ContactNotes;

       

      InvoiceState:

      Load

      @ContactKey,

      '' as ContactDate,

      '' as ContactNotes

      Resident InvoiceContactFINALTable;

       

      STORE InvoiceState INTO InvoiceState.qvd (qvd);

       

      Drop Table InvoiceState;

       

      InvoiceStateQVD:

      Load

      @ContactKey,

      ContactDate,

      ContactNotes

      FROM

      InvoiceState.qvd (qvd);