topic Help on Inputfield in QlikView

Help on Inputfield

Mon, 28 Dec 2009 23:25:45 GMT

Hello.

I'm developing a qv application and i need the user to change certain values on an pivot table.

I Know the use of inputfiled but the problem is that i need to change the values of a calculated expresion that I can not load in the script

I Have a column (NO INPUTFIELD) with the results and i need to copy this values to another column and use inputsum in the new column

Can anybody help me?

Sorry for my English

Thanks in advance

Help on Inputfield

Mon, 28 Dec 2009 23:52:36 GMT

You have to write a macro to do that. In your case, you will cycle the first column and write the inputfield column with the corrisponding value. At the end, you will be able to manually use the inputfield as you do when its value is 0.

It is not very easy: see document "APIguide.qvw" included in standard documentation for the syntax of inputfield manipulation commands.

Bye

Paolo

Help on Inputfield

Wed, 30 Dec 2009 15:22:57 GMT

First of all, thanks for your answer.

The problem is that i need help to buildl this macro

If someboy can help me i would aprreciate.

Thanks

Help on Inputfield

Wed, 30 Dec 2009 16:11:12 GMT

Hi,

How about creating a duplicate column with different name and defining it as inputfield in the script? You can then use this column in 'inputsum'.

Example:


Inputfield Col3;
LOAD Col1,
 Col2,
 Col2 as Col3
FROM Table;

Help on Inputfield

Wed, 30 Dec 2009 16:26:54 GMT

Thanks for the answer

I try to explain the problem

Column3 is the result of an operation

[Column1+Column2/Column3] for expample

I can not do that on the script because any column has data of diferent tables

Happy new year for everyone

Help on Inputfield

Sat, 30 Jan 2010 19:46:55 GMT

Here's the macro i wrote

sub asignavalores

set fld = ActiveDocument.Fields("ventas2")
set table = ActiveDocument.GetSheetObject( "CH01" )
w = table.GetColumnCount
h = table.GetRowCount
set CellMatrix = table.GetCells2(0,0,w,h)
for RowIter=1 to h-1

valor=CellMatrix(RowIter)(2).Text

FLD.SetInputFieldValue RowIter-1, valor

next

end sub

The problem is that it does not copy the values correct, in order, and i don't kow why

The only thing i need is edit the 2 column, wich is the result of an operation

Re: Help on Inputfield

RSvebeck — Tue, 18 Feb 2014 09:03:05 GMT

Did you find a solution to this issue? I'm not successful in using SetInputFieldValue either.... //Robert