Solved: Re: Input Box - Qlik Community

siddheshmane · ‎2015-04-02

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.

siddheshmane · ‎2015-04-03

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

NareshGuntur · ‎2015-04-03

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

Anonymous · ‎2015-04-03

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

siddheshmane · ‎2015-04-03

Hello Sir,

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

Thanks.

Anonymous · ‎2015-04-03

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

NareshGuntur · ‎2015-04-03

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

Cheers,

Naresh

siddheshmane · ‎2015-04-03

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.

Anonymous · ‎2015-04-03

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

siddheshmane · ‎2015-04-03

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

Anonymous · ‎2015-04-03

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