topic problem with Text color in pivot table in QlikView

problem with Text color in pivot table

Tue, 06 Dec 2011 09:51:11 GMT

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

Re: problem with Text color in pivot table

jagan — Tue, 06 Dec 2011 12:40:28 GMT

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.

problem with Text color in pivot table

Tue, 06 Dec 2011 13:18:45 GMT

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!

problem with Text color in pivot table

jagan — Tue, 06 Dec 2011 14:23:17 GMT

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.

problem with Text color in pivot table

Wed, 07 Dec 2011 09:02:03 GMT

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

problem with Text color in pivot table

jagan — Wed, 07 Dec 2011 11:06:40 GMT

Hi,

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

Regards,

Jagan.

Re: problem with Text color in pivot table

Wed, 07 Dec 2011 11:56:43 GMT

Hi,

Find the qvw attach

Thank you for your help

problem with Text color in pivot table

jagan — Wed, 07 Dec 2011 12:06:40 GMT

Hi,

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

Regards,

Jagan.

Re: problem with Text color in pivot table

Wed, 07 Dec 2011 13:28:33 GMT

Thank you very much Jagan...

Have a nice day!