topic Re: Set Font Colour within Concat expression in QlikView

Set Font Colour within Concat expression

Thu, 11 Jul 2013 14:25:34 GMT

Hi,

I have the following expression : concat(distinct name, ', ')

Is it possible to set the colour of each 'name' when it is displayed depending on a condition. For Example if the expression lists : Name1, Name2, Name3

could I turn the colour of Name2 to Red if a variable 'vNumber' is less than 'Target' ?

Many thanks

Re: Set Font Colour within Concat expression

Gysbert_Wassenaar — Thu, 11 Jul 2013 14:28:05 GMT

Yes, click on the + in front of the expression and select Text Color. You can then enter an expression in the Definition field: if(vNumber<Target, red())

If that didn't work we need more information. Please post a sample document:

Preparing examples for Upload - Reduction and Data Scrambling.

Re: Set Font Colour within Concat expression

Thu, 11 Jul 2013 15:33:37 GMT

Hi thanks for your reply.

What I am trying to acheive is this :

But by using your example - the whole 'cell' text has turned one colour or another. Please see attached file.

Many thanks again.

Re: Set Font Colour within Concat expression

Gysbert_Wassenaar — Thu, 11 Jul 2013 15:41:13 GMT

No, that's not possible. The concatenated string is only one string, only one value. That's why it can have only one background or text color.

Re: Set Font Colour within Concat expression

Thu, 11 Jul 2013 15:47:12 GMT

I thought so - is there another way of showing this (eg, in seperate cells)?

Re: Set Font Colour within Concat expression

Gysbert_Wassenaar — Thu, 11 Jul 2013 15:56:47 GMT

Yes, with each value in a separate cell you can give each value its own color. In your sample document you will need to select only one month. Or you have to change the if condition because for each target-name combination there are months where Number < Target and months where Number > Target. And one cell can't have two colors at once so you'll have to make sure there's no ambiguity.