Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table with a traffic light field

Hello

I have a table as shown below, where a I need to add a colored column according to "SEMAFORO_ALIANZAET" value. For example, if the value is "2. PRÓXIMO A VENCERSE"  the new field must be yellow colored and so on.

I will appreciate your help.

pivot_table_traffic_light.JPG

1 Solution

Accepted Solutions
vikasmahajan

PFA sample application

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

6 Replies
sudeepkm
Specialist III
Specialist III

Have you tried using the Dimension background color using a condition. Given below is an example.

T179863.PNG

Anonymous
Not applicable
Author

Sudeep, thank you very much for your answer. In your example, in the case DENMARK needs to be red colored and FRANCE blue, how would be the expression?

vikasmahajan

PFA sample application

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Anonymous
Not applicable
Author

Vikas, thank you very much for your help.

vikasmahajan

Welcome

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

any chance this could be in QVF