Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add record in table inputfield

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

8 Replies
Not applicable
Author

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

skaredovs
Partner - Creator
Partner - Creator

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

Konstantins

Not applicable
Author

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

skaredovs
Partner - Creator
Partner - Creator

Dinamic Data Update works only in QV9.

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

BR,
Konstantins

Not applicable
Author

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

Does exist something like remove() ?

Thanks

Best Regards /CIAO

Slash

Not applicable
Author

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

Thanks

Best Regards

Slash

skaredovs
Partner - Creator
Partner - Creator

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

Not applicable
Author

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,