topic Help regarding input field/input sum in QlikView

Help regarding input field/input sum

Thu, 17 Jan 2013 08:19:32 GMT

Hi all,

I've a small query regarding input sum. I've taken an input field and displayed input sum of that field in straight table, which is editable now.

The thing is I've to display a field that shows whether the input field value is modified or not.

Kindly help me regarding this.

Thanks,

Surendra

Thu, 17 Jan 2013 09:51:29 GMT

Any idea on the above query??

swuehl — Thu, 17 Jan 2013 09:56:30 GMT

I think you need to keep your original data in a field, thus allowing to compare the original value with the input field value:

INPUTFIELD Test;

LOAD Test, Test as OrigTest, rowno() as ID INLINE [

Test

];

So when you create a straight table chart with dimension ID, and expressions

=inputsum(Test)

and

=OrigTest

, you can highlight changes e.g. by creating a background color attribute for OrigTest expression:

=if(OrigTest <> Test, lightred() )

Hope this helps,

Stefan

er_mohit — Thu, 17 Jan 2013 09:58:51 GMT

try

inputsum(fieldname)

but it doesnot work on conditions expression