topic Text Colour & Font in Strainght/Pivot Table in QlikView

Text Colour & Font in Strainght/Pivot Table

Fri, 23 Apr 2010 13:04:03 GMT

Hello,

I wanted to know if the following is possible.

The data i have in a straight or pivot table is '459314567789' and i want to change the colour of the 6th to the 8th number to red and make it bold while the rest would be black and normal.

Thanks,

Ankur

Text Colour & Font in Strainght/Pivot Table

boorgura — Fri, 23 Apr 2010 15:04:38 GMT

Hey Ankur,

If that is the value in an expression, you can set the color or BOLD, by expanding the expression and editing the Background or Text option.

Else, if you want to format a particular (or a few) cell, then you can context click on the cell and select Custom Format cell.

Text Colour & Font in Strainght/Pivot Table

johnw — Fri, 23 Apr 2010 22:49:39 GMT

I don't think you can format just part of a field separate from the rest of the field. Perhaps if you split it into multiple fields, removed the vertical bars in the chart, and smashed the columns right up next to each other?

Text Colour & Font in Strainght/Pivot Table

Sat, 24 Apr 2010 12:18:17 GMT

=-0987ello Rocky,

Thank you for your reply, the value is coming from the DB as is.

Hi John,

Regarding your idea can you attach a small example for me.

I was trying to use the left/right trim function but instead of trim tried colour instead. Just giving it shot.

Will await your example.

Thank You,

Ankur

Text Colour & Font in Strainght/Pivot Table

pover — Sun, 25 Apr 2010 07:05:38 GMT

Ankur,

Attached is a solution like John mentioned. I can't think of a better work around for now.

Regards.

Text Colour & Font in Strainght/Pivot Table

Sun, 25 Apr 2010 10:41:57 GMT

Hello Karl,

Thank you for the example.

Regards,

Ankur