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

Announcements
Join us in Bucharest on Sept 18th 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