problem with Text color in pivot table

[#1]

Hello everybody,

I have a stange problem with my pivot table. I want Text color on a dimension.

I have this pivot table, and I want to write the name according to the value of the column index.

I have this formule in text color on dimension NAME =if(Only(INDEX)='A',RGB(0,0,0),RGB(0,0,255))

It's ok for Equipe 1 but not for this other or it's ok when I selected one person or one equipe.

I think is due to the other equipe have not data for the JOUR 1.

Have you any idea to resolve my problem?

I have tried tu use aggr or only or maxstring formula but i'm not arrived to the solution...

Thank you for your help.

Have a nice day.

Bye

[jagan]

Hi,

Use the following color expression

=If(Index='A', RGB(0,0,0), If(Index='B', RGB(0,255,0), RGB(0,0,255)))

Regards,

Jagan.

[#3]

Hi Jagan,

Thank you for your help!

your formula is ok and it's ok in my application,

the problem is when the person have no data from the fisrt day.

How say to Qlikview, to take the index however data???????

thank you for your help!

[jagan]

Hi,

Can you explain your requiement with an example.  I didn't understand what you are expecting.  Attach a sample it would be very helpful.

Regards,

Jagan.

[#5]

Hello Jagan,

Thank for your help!

You have the example in the XLS files i join in my first post...

My problem is for (from the image above) the second equipe: the formula don't do the color coding since no data are existing for the equipe 2 in the DATE JOUR 1...

Do you understand my problem?

Can you help me to make formula ok for all equipe regardless of the data?

Thank you

[jagan]

Hi,

Can you please upload the Qlikview file that you are working.

Regards,

Jagan.

[#7]

Hi,

Find the qvw attach

Thank you for your help

[jagan · Accepted solution]

Hi,

Uncheck the "Supress Zero-Values" option in Presentation tab of Chart properties and you issue will be solved.

Regards,

Jagan.

[#9]

Thank you very much Jagan...

Have a nice day!