topic Add record in table inputfield in QlikView

Add record in table inputfield

Mon, 19 Oct 2009 15:07:10 GMT

Him
in this sample I poy the 2 fields in input mode:
inputfield salesman, qty ;

Load * Inline [
salesman, qty
Joe, 50

];

After this script I can to build a table.
In the table appears 1 row:

----------------------
salesman | qty
----------------------
Joe | 50
----------------------

Is it possible to add a new row "out of the script"?
If I want to insert :
salesman qty
Paul 100
I need to update the script:
inputfield salesman, qty ;
Load * Inline [
salesman, qty
Joe, 50
Paul, 100
];
But I would to know is it possible to append a "array" directli of the front-end;
Thanks

Best Regards
Slash

Add record in table inputfield

Mon, 19 Oct 2009 17:15:53 GMT

Input Fields allow you to update the values alread listed, not append.

If you want to append, you can cheat using Excel files or via a macro save the new values into a file that you'll reload after.

Rgds,

Sébastien

Add record in table inputfield

skaredovs — Mon, 19 Oct 2009 17:24:21 GMT

Additionally to Sebastien said, there is example in QV9 installation package where you will find how to use new feature Dynamic Data Update.

Konstantins

Add record in table inputfield

Mon, 19 Oct 2009 19:01:42 GMT

Interesting...

but I use the 8.50 release in my company. Please did you know if the application works by QV 8.50? Evenually where can I found it?

Thank you very much

Best Regards/CIAO

Slash

Add record in table inputfield

skaredovs — Mon, 19 Oct 2009 19:14:44 GMT

Dinamic Data Update works only in QV9.

In 8.50 you can use partial reload. See attachment for my example.

BR,
Konstantins

Add record in table inputfield

Mon, 19 Oct 2009 22:20:48 GMT

thanks. But If I qould to REMOVE one row?Interesting Add() function.

Does exist something like remove() ?

Thanks

Best Regards /CIAO

Slash

Add record in table inputfield

Tue, 20 Oct 2009 13:44:36 GMT

My question is if exists the inverso of ADD() function?

Thanks

Best Regards

Slash

Add record in table inputfield

skaredovs — Tue, 20 Oct 2009 14:12:40 GMT

No. There is no REMOVE() function in partial reload. In QV9 it exists in Dinamic data update functionality.

You can find in the documentation examples of partial reload with functions similar to REMOVE.

BR
Konstantins

Add record in table inputfield

Tue, 20 Oct 2009 14:35:29 GMT

In partial reload you have the ADD function and Replace function

You can remove values using inner join or other links features of qlikview. For example you define the keys to remove in additionnal Excel files.

Regarding the dynamic data update in V9, you need a special server licence if you want to use it with QVS.

Rgds,