topic Re: Edit Tables in QlikView

Edit Tables

Thu, 09 Oct 2014 12:59:33 GMT

Hi Everyone!

I wanted to know if anyone knows a method that allows to add one or more empty rows in a table, where I can insert new data that can be loaded into QVD.

Is there a way to do this or is it pure fantasy ?!

Re: Edit Tables

sorrakis01 — Thu, 09 Oct 2014 13:04:44 GMT

Hi Gabriele,,

You need to use a LOAD CONCATENATE to do it.

Look this link http://community.qlik.com/message/567483#567483

Regards,

Re: Edit Tables

Thu, 09 Oct 2014 13:13:17 GMT

Sorry perhaps I expressed badly ... I wanted to know if i could create, edit and reload a new row in a simple table or a pivot table and not directly working on the script.

Re: Edit Tables

sorrakis01 — Thu, 09 Oct 2014 13:16:47 GMT

I think that's not possible, but...... maybe someone can confirm it!

Ciao,

Re: Edit Tables

alex_millan — Thu, 09 Oct 2014 13:18:48 GMT

Hi Gabriele,

Not from what I know. Once the script is finished the whole set of data is closed.

Any modification must be done by the script.

Cheers!

Re: Edit Tables

Anonymous — Thu, 09 Oct 2014 13:23:31 GMT

Have a look at the Q-Eye bolt on product.

Re: Edit Tables

MarcoWedel — Sat, 11 Oct 2014 01:14:20 GMT

You might create input fields using the "inputfield" statement to edit existing field values (that might be loaded as placeholder values during script execution).

hope this helps

regards

Marco

Re: Edit Tables

Tue, 14 Oct 2014 07:16:58 GMT

I know this way, but if i use inputfield when i reload data i lose all data entered through the inputfield.

Re: Edit Tables

SergeyMak — Tue, 14 Oct 2014 07:20:47 GMT

I'm just thinking What For?

What is the goal?

Re: Edit Tables

Tue, 14 Oct 2014 07:36:29 GMT

The goal is to allow the user to edit the tables so that you can keep data up to date without having to update continually the excels files.

Re: Edit Tables

SergeyMak — Tue, 14 Oct 2014 07:46:57 GMT

ok.. But I have another question: What is the main data source for your app?

Re: Edit Tables

Peter_Cammaert — Tue, 14 Oct 2014 08:00:10 GMT

Well, IMHO in many business environments QlikView replaces Excel because QV is a BI/Business Analytics application and not really a Data Messing tool. In QV the path from source data to display is devoid of features for uncontrolled modification of this data. Which helps to guarantee that this is "the truth" and there is only one version of it. Even the INPUTFIELD feature (almost the only one that supports adding column values to a table) produces strictily isolated data sets that can only be saved/exported to a data store that is external to the QlikView model.

I guess in your case - and because you want to add rows - there is a simple solution, but it relies on the load script to perform its duties: create a fixed layout excel and just load it by default in the load script and concatenate it to the target table you want to add rows to. Do not rely on the quality of the data in it: apply extensive validation rules on the content of the file, so that you can be sure that you're not adding garbage to an otherwise clean data set.

Make the script so that the file must be there, but shouldn't really contain anything per se. If it's empty, that's perfectly ok.

Share the file with whoever is permitted to influence the data in this table..

BTW IIRC INPUTFIELD cannot be used to arbitrarily add rows to a table in the UI.

A few years ago, I stumbled upon QV-based applications that supported data modification through the use of their own custom objects (was it for budgetting or forecasting?) Lost track however. Check the Qlik Market for tools and/or extensions that may provide what you are looking for.

Good luck,

Peter

Re: Edit Tables

Tue, 14 Oct 2014 08:01:20 GMT

I've got only the excel files, because my project manager gave me those, then i don't know the origin of the data in excel files.