topic Division using Inputfield and inputsum in QlikView

Division using Inputfield and inputsum

renjithpl — Fri, 23 Nov 2012 08:56:15 GMT

Hi All,

Is it possible to edit the column using an inputfield where a division is made?

for eg,

INPUTFIELD Amt;
LOAD * INLINE [
Code, Amt
A, 100
B, 200
C, 300
];

INPUTFIELD amt1;
LOAD * INLINE [
Code, amt1
A, 400
B, 500
C, 600
];

THen in a straight table, my expression is inputsum(Amt)/Inputsum(amt1)

but i am not able to edit this column.

is there anyother way where i can edit this, or i cannot?

regards

renjit

Re: Division using Inputfield and inputsum

its_anandrjs — Fri, 23 Nov 2012 09:03:41 GMT

Hi,

Use Table box to change the values in Straight table when you change a value in Table box the value reflects in the straight table.

Regards,

Anand

Re: Division using Inputfield and inputsum

renjithpl — Fri, 23 Nov 2012 09:11:26 GMT

I want to edit the expression column, is that possible ?