topic Doubt Colors in Fields by Expression in QlikView

Doubt Colors in Fields by Expression

Anonymous — Thu, 21 Sep 2017 16:45:40 GMT

Hello,

I'm generating a table where I group for a given service, several tasks. These tasks have different priority (critical, average and low) and I need to display a color map per service.

If any task is critical, turn it red. (regardless of whether you have medium or low tasks)

If any task is average, and has no criticisms, it turns yellow

If all tasks are low, they turn green.

Example:

Service	Task	Color
Service1	Task 1: Critical Task 2: Media Task 3: Media Task 4: Low	Red
Service 2	Taks 1: Low Task 2: Low Task 3: Media	Orange
Service 3	Task 1: Low Task 2: Low Task 3: Low	Green

Service

Task

Color

Service1

Task 1: Critical

Task 2: Media

Task 3: Media

Task 4: Low

Red

Service 2

Taks 1: Low

Task 2: Low

Task 3: Media

Orange

Service 3

Task 1: Low

Task 2: Low

Task 3: Low

Green

thank you very much!

Re: Doubt Colors in Fields by Expression

marcus_sommer — Fri, 22 Sep 2017 07:09:41 GMT

This could be done with the attribut expressions - behind the small plus-signs by dimensions and expressions - with an expression like:

pick(match(Task, 'Critical', 'Media', 'Low'), red(), yellow(), green())

- Marcus

Re: Doubt Colors in Fields by Expression

Anonymous — Fri, 22 Sep 2017 14:44:59 GMT

Hi Marcus,

thank you, i Need add a new conditional:

If status is assignated and exist some critical, is red,
If status is assignated and exist some media and any critical, is yellow
if all task, status are closed, is green,
If all taks are low, and status is assignated, is green.

Can you help me?

Regards.

Re: Doubt Colors in Fields by Expression

marcus_sommer — Mon, 25 Sep 2017 06:35:16 GMT

You could try to concat the conditions like:

pick(match(Status & '|' & Task, 'Assigned|Critical', 'Assigned|Media', ....),

red(), yellow(), green())

Depending on the conditions it might be easier to use if-loops and/or to combine if-loops with pick(match()) like:

if(Status = 'Closed', green(),

pick(match(Status & '|' & Task, 'Assigned|Critical', 'Assigned|Media', 'Assigned|Low'),

red(), yellow(), green())

- Marcus