topic Re: Add manual values in QlikView

Add manual values

Thu, 19 Feb 2015 13:54:04 GMT

Hi everybody,

I have a question :

I have a graphic (table) with datas which are based on a ERP' Database (as you can see in the picture).

But i would like to add manual values (just total) and the end of the table.

For exemple i would like to add on the table a line which is called FINITION and the value of the "CA total" is 3 943 281 € and others lines which are calculed with the line FINITION and datas of the database...

May be made a "inline"?

Excuse me for my bad english and it is not clear but please look at the picture i think this is more clear.

Thanks a lot !

Re: Add manual values

Anonymous — Thu, 19 Feb 2015 14:26:30 GMT

if I correctly understand the question, you want to enter some manual values in table. To enter values manually in a table you can load a table and then make a field inputfield. The script would be something like this.

INPUTFIELD [Proposed Salary];

Proposal:

LOAD

[Contract Id],

Junior/Middle/Senior,

Proposed Salary

From ..\abc;

Re: Add manual values

Thu, 19 Feb 2015 14:50:38 GMT

Thanks qlikrajan ok for imputfield but i don't want to enter a new filed, just enter manual "lines"..

Thanks a lot

Re: Add manual values

mukesh24 — Thu, 19 Feb 2015 15:23:24 GMT

U want to enter manual line in table right?

use na Inputfield n call these field in Table as Rajan suggested.