topic Custom value? in QlikView

Custom value?

n1ef5ng1 — Mon, 01 Jul 2013 07:15:55 GMT

Is there any way I can create a custom value on the table that will affect the value?

Date	Name	Salary	Adjusted (Custom Column)	New Salary
11 jan	james	1500	20	1520
14 jan	mary	2222	111	2333
28 jan	peter	3333		-
15 may	jon	40	40000	40040

The adjusted colum is the colum that I want user to input value that will affect the result of the salary on the pivot table,

is there anyway i can do that>

thanks

sivarajs — Mon, 01 Jul 2013 07:32:59 GMT

You can input values see the example below

1.Create input field (field you want use a input) in script

INPUTFIELD fieldname; // like how you create let, set field

2. After reloading in table

INPUTSUM(your input field) //As field in step 1

3.For your new salary column use

inputsum(INPUTSUM(your input field))+Salary