Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
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

17 Replies
Highlighted
Partner
Partner

Hi Siddhesh,

Inputbox assigns value to variable. As variable can hold only one value at any instance, the previous value will not be present.

Cheers,

Naresh

Highlighted
Creator III
Creator III

Hi Siddhesh,

you can not append some value to your data table in QV model at run time.

Qlikview or BI tools are to show the data as it in and not for write back facility

Highlighted
Creator
Creator

Hello Sir,

So is there any way so that I can insert multiple values in the table. without using so many input boxes?

Thanks.

Highlighted
Creator III
Creator III

further please share your sample app for better understanding of the problem

Highlighted
Partner
Partner

Can you elaborate what you are trying to do so that we can think of another approach

Cheers,

Naresh

Highlighted
Creator
Creator

Hi,

I have shared my qv file.  The requirement is that I need to input values into the table. But as seen I cannot input more than one value for a variable. The previous variable value gets overwritten. I have created an input box with variables

ShipDate

Customer

SalesOrderID

Product

Sales

Quantity.

I input values into these variables and then the variables are loaded in the table.

Now, what if I want to load another value to the table from the input.

Thanks.

Highlighted
Creator III
Creator III

While reloading reload your base file then concatenate inline load from variables and store it in qvd

and while doing next reload use the data from qvd and append with fresh values from variables

Highlighted
Creator
Creator

Hello Sir,

I tried using your method, but it doesn't seem to work. Please tell me if I have missed any steps.

- I loaded the excel file into the script,

- Loaded the inline values and concatenated them to the table.

- Stored the values into a .qvd file.

- Dropped the previously loaded excel table.

- Loaded the .qvd file in the Script.

- Loaded the inline values and concatenated them to the new table

Highlighted
Creator III
Creator III

do it in this steps

SalesDesc:

Load variable values inline;

if( exists(inputentries.qvd))

concatenate

  Load * from inputentries.qvd(qvd)

end if

Store SalesDesc into inputentries.qvd(qvd);

Concatenate

load excel