topic Staright Table Cell With Different Color Of Words in QlikView

Staright Table Cell With Different Color Of Words

Fri, 06 Dec 2013 11:20:09 GMT

Hi all,

i have straight Table in which am calculating fields in that fields i want to get Different Color for in cell for Calculated field And indicator Value

Please take look at Excel And Image

Re: Staright Table Cell With Different Color Of Words

a_mullick — Fri, 06 Dec 2013 11:56:14 GMT

Hi,

The only way I could something like this is to allocate a seperate column for the indicator. So in the example below, we see column 1 and 2 containing figures for YTD and YTD -1; column 3 is just a spacer column and column 4 is calculated column to decide which image (red down arrow, or green up arrow) to display depending on the relation between column 1 and 2. Hope that helps. p.s. this would also work if you decided to use UNICODE characters instead of images, but then you would also need to conditionally set the font colour too.

Which gives something like...

Re: Staright Table Cell With Different Color Of Words

Fri, 06 Dec 2013 12:09:51 GMT

Hi Azam ,

Thanks For Replaying Me

but i have Two problems first i want both that indicator and Figure In single Column and I want that figure in black

and indicated should be multicolored

Re: Staright Table Cell With Different Color Of Words

Fri, 06 Dec 2013 12:10:43 GMT

Please upload that Qvw file

Re: Staright Table Cell With Different Color Of Words

Fri, 06 Dec 2013 12:18:17 GMT

i don't know about

UNICODE characters implementation in qlikview

if you have any example file about this please upload for me

Re: Re: Staright Table Cell With Different Color Of Words

a_mullick — Fri, 06 Dec 2013 12:27:06 GMT

Hi,

Sure, I understand, but I couldn't find a way to mix and match 2 colours in one cell. I can't share the qvw with you, but here is a simple example based on the same principle using unicode characters.

Thanks,

Re: Staright Table Cell With Different Color Of Words

Fri, 06 Dec 2013 12:30:39 GMT

Thanks

for file