Format text colors not consistent

[#1]

Hi all,

I have created a calendar view and am trying to format the expression text based on the 'Off_Type'.

Here is my formula:

=if(Off_Type = 'Vacation',LightBlue(),if(Off_Type = 'Sick',LightRed(),if(Off_Type = '[Comp Day]',lightGreen(),
if(Off_Type = '[Bereavement / Compassionate]',DarkGray(),
if(Off_Type = '[Other Work Assignment]',DarkGray())))))

Unfortunately, not all days in the calendar are cooperating where the text on 3/2 is red as expected but those on 3/9 "Sick" are not red:

It appears when multiple Off_Types fall on a given day, the formatting doesn't work.  Any information or explanation is much appreciated!

[dsharmaqv]

post your app please

[adamdavi3s]

Hi John,

Can you upload your QVW, maybe scramble a few fields so its not sensitive any more!

[adamdavi3s]

John,

If it makes life easier I have created a dummy set, how does this differ from yours in the simplest terms?

Also the following formula is a slightly more efficient way of doing this

=pick(match(Off_Type,'Vacation','Sick','Comp Day','Bereavement / Compassionate','Other Work Assignment'),LightBlue(),LightRed(),lightGreen(),DarkGray(),DarkGray())

[#5]

Here you go...

[adamdavi3s]

I do not know of a way of doing this I am afraid, you can't format text with different colours within the same cell, qlik just won't do it.

Because you have multiple different off_type, qlik can't work out which one you want which is why it is just black

[#7]

Shoot...I was afraid of that!