Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Input Box

Hi,

How do I insert multiple values from a single input box. When I insert a value in the input box and append it to the original table and Later when I try to insert a different value in the input box, it overwrites the old value.

Thanks.

Capture.PNG

17 Replies
Highlighted
Creator
Creator

Hi Sir,

I tried the steps you mentioned, but the values are still being overwritten. This is my code. Please review and suggest if there are any errors.

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

STORE SalesDesc into 'D:\Projects\Test.qvd';

Is there any way to store two values of a single field using one input box.

Thanks.

Highlighted
Creator III
Creator III

Can you share this sample QVW and the excel file you are trying to load

Highlighted
Creator
Creator

Hi,

Here are the qv file and the excel data.

Thanks.

Highlighted
Creator
Creator

Bhagirath‌‌, Thank You Sir, for the effort you took into explaining me the solution.

I got the answer finally. The code is as you said. I just had to do a Partial Reload everytime I want to add a value.

----------------------------------------------------------------------------------------

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

SalesNewDesc:

ADD LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

STORE SalesDesc into 'D:\Projects\Test.qvd';

------------------------------------------------------------------------------------

Adding the ADD keyword before the LOAD fucntion allows to partial reload..

Thanks.

View solution in original post

Highlighted
Creator III
Creator III

Hi Siddhesh,

Can you please recheck, make sure every time you enter values to input box u need to save your document and then reload

i have done some dummy entries, see the attached QVD and paste it in the same location where qvw is.

I dont think you can this input solution for Acesspoint, because the reload at server will not save values of variables user has changed.

anyways you can mark my solutions correct or useful if it has helped you

Highlighted
Creator
Creator

Yes. Every time I reload, the values are entered into the table and then saved into the qvd file. But as you said this won't be the case while doing a reload at server.

Thanks.

Highlighted
Creator
Creator

I am also attaching you the file. You can check and suggest me if I have made a mistake.

Highlighted
Creator III
Creator III

you do not need this statement

SalesNewDesc:

ADD LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

as you have already loaded the same in SalesDesc

below script is fine

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

STORE SalesDesc into 'D:\Projects\Test.qvd';

you can load the excel file data immediately after this and get that concatenated with the SalesDesc table