Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help regarding input field/input sum

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

3 Replies
Not applicable
Author

Any idea on the above query??

swuehl
MVP
MVP

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

1

2

3

4

];

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
Master II
Master II

try

inputsum(fieldname)

but it doesnot work on conditions expression