topic Formatting in QlikView

Formatting

Fri, 12 Oct 2012 15:48:09 GMT

Hi,

I have a table in which one column is a percentage variance between two other columns which is set up with visual cues to show as red or green depending on whether it is negative.

This is working brilliantly but the table is quite small so this is not good when i want to use this for presentational purposes.

I have created text objects to display some of the key fields in large type which is working well but i want to reflect the visual cues in the text object that has the percentage variance in it. Is this possible?

Thanks

Re: Formatting

Fri, 12 Oct 2012 16:32:12 GMT

Maybe I am misinterpreting your question, but have you thought about using something like this?

Re: Formatting

whiteline — Fri, 12 Oct 2012 19:33:43 GMT

Hi.

If you want dynamic text color you can try this:

Properties->Font->Color->Calculated

Enter the expression that returns different colors depending on your conditions.