topic Change Color for InputFields in QlikView

Change Color for InputFields

Anonymous — Fri, 11 Sep 2009 00:56:02 GMT

I have a "What If" column in a pivot that I'd like to make the data and/or background color change if the user changes the default data loaded in that column. Anyone know how to do this?

Change Color for InputFields

disqr_rm — Fri, 11 Sep 2009 01:32:58 GMT

Can you load same data into another field and then compare to set color of the cell? Would that work for you?

Otherwise, please attache a simple sample document here.

Change Color for InputFields

Anonymous — Fri, 11 Sep 2009 01:56:26 GMT

Thanks Rakesh, but I figured it out.

Change Color for InputFields

disqr_rm — Fri, 11 Sep 2009 02:36:57 GMT

Could you please share your solution with the community? Thank you.

Change Color for InputFields

Anonymous — Fri, 11 Sep 2009 02:43:23 GMT

In the load script I preload the input field with the same values as the original column, then in the pivot chart I just check to see if the value is different. I put the following in the Text Color property of the Expression holding the input field:

(column(10)<>column(9),rgb(0,0,255))