topic Re: marking certain values in red in QlikView

marking certain values in red

Tue, 26 May 2015 11:38:38 GMT

Hi Community

I have created a table box. There is a column called variance in that. I want to make it in such a way that when the values in variance is less than 0, the values displayed less than zero should be displayed in red colour .But the other values should be displayed as normal. How to enable this functionality? Please help.

Regards

Smriti

Re: marking certain values in red

Tue, 26 May 2015 11:43:52 GMT

Hi Smriti,

within a table box I don't think you'll be able to do this, if you change to a straight table though, you can set this up under the visual cues properties tab.

Hope that helps

Joe

Re: marking certain values in red

Tue, 26 May 2015 11:44:05 GMT

Smriti,

i don't think this can be achieved in a table box. because we cannot modify fields in that.

You can easily achieve this in any chart or straight table.

Re: marking certain values in red

Anonymous — Tue, 26 May 2015 11:45:05 GMT

Hi ,

I think the requirement you are looking for is not possible in table box we cant perform any calculations in table box it will dislplay only data .

Its possible in straight table .

Thanks

Re: marking certain values in red

sunny_talwar — Tue, 26 May 2015 11:45:29 GMT

I don't think that you can do color coding in a table box, but you might be able to replicate a table box using a straight table and use that to create color conditions.

Best,

Sunny

Re: marking certain values in red

Tue, 26 May 2015 12:09:10 GMT

Thankyou Joe

I am able to do this through straight table.