topic Store inputfield in QVD in QlikView

Store inputfield in QVD

Fri, 05 Apr 2013 23:00:00 GMT

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);

Re: Store inputfield in QVD

Gysbert_Wassenaar — Sat, 06 Apr 2013 09:23:44 GMT

The replacement value is user dependent, i.e. when an input field is used on a server, different users will see different sets of input field values

That means that if the document is deployed on the server there's no way to store the changed values to a qvd.

If the document is opened locally with Qlikview Desktop then your script should store the changed values according to this post.

Re: Store inputfield in QVD

Mon, 08 Apr 2013 02:32:44 GMT

Thank you, Gysbert. I have deployed my document on the server to test and you confirmed my suspicions that I am unable to store input fields by trying to store them in a QVD.

So now that that option is thrown out, what other options are available to store input fields? Any suggestions are welcome because now I'm stuck!

Re: Store inputfield in QVD

Mon, 08 Apr 2013 10:15:37 GMT

Hi Mike,

You can use a macro :

First select your object table with INPUTFIELD :

set tb = ActiveDocument.GetSheetObject("MY_TAB")

Then export it in a QVD :

tb.ServerSideExportEx "MY_TAB.qvd" ,";",4

Re: Store inputfield in QVD

Mon, 08 Apr 2013 14:57:03 GMT

Hi Mike

I had the same problem. I went thru a macro to generate files

best regards

chris

Re: Store inputfield in QVD

Mon, 08 Apr 2013 19:24:19 GMT

Thank you, Benoit and Chris. Since I am new to this I have not yet created a macro. Do you have recommendations on the steps I need to take to create a macro? Thanks!