Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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
Hello Sir,
So is there any way so that I can insert multiple values in the table. without using so many input boxes?
Thanks.
further please share your sample app for better understanding of the problem
Can you elaborate what you are trying to do so that we can think of another approach
Cheers,
Naresh
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.
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
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
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