topic Re: Input Box in QlikView

Input Box

siddheshmane — Fri, 03 Apr 2015 03:44:58 GMT

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.

Re: Input Box

NareshGuntur — Fri, 03 Apr 2015 05:16:02 GMT

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

Re: Input Box

Anonymous — Fri, 03 Apr 2015 05:30:08 GMT

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

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 05:30:45 GMT

Hello Sir,

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

Thanks.

Re: Input Box

Anonymous — Fri, 03 Apr 2015 05:31:12 GMT

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

Re: Input Box

NareshGuntur — Fri, 03 Apr 2015 05:32:58 GMT

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

Cheers,

Naresh

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 05:44:06 GMT

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.

Re: Input Box

Anonymous — Fri, 03 Apr 2015 05:56:49 GMT

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

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 06:51:55 GMT

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

Re: Input Box

Anonymous — Fri, 03 Apr 2015 07:19:11 GMT

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

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 11:29:50 GMT

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.

Re: Input Box

Anonymous — Fri, 03 Apr 2015 11:42:44 GMT

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

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 11:46:43 GMT

Hi,

Here are the qv file and the excel data.

Thanks.

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 11:58:01 GMT

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.

Re: Input Box

Anonymous — Fri, 03 Apr 2015 12:02:29 GMT

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

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 12:15:46 GMT

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.

Re: Input Box

siddheshmane — Fri, 03 Apr 2015 12:22:41 GMT

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

Re: Input Box

Anonymous — Fri, 03 Apr 2015 14:16:29 GMT

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