Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
xyz1
Contributor III

?

.

1 Solution

Accepted Solutions
MVP
MVP

Re: Color Expression

Like this, perhaps:

If(Match(Phase, 'Project', 'Opportunity', 'Feasibililty'),
If(Commitment = 'On Schedule',  1,
If(Match(Commitment, 'Delayed', 'Incomplete Info'),  4,

If(Phase  =  'Future' And Commitment = 'Future', 3,
If(Phase  =  'Closed', 9
If(Match(Phase, 'Future', 'Delayed'), 8,
)))))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
Partner
Partner

Re: Color Expression

Hello,

I think you can´t use Masteritems color with this extension by now.

I think for another color you must change the style.css in the Extension folder.

Partner
Partner

Re: Color Expression

In the Qlik Desktop:

looks:

xyz1
Contributor III

?

.

MVP
MVP

Re: Color Expression

Like this, perhaps:

If(Match(Phase, 'Project', 'Opportunity', 'Feasibililty'),
If(Commitment = 'On Schedule',  1,
If(Match(Commitment, 'Delayed', 'Incomplete Info'),  4,

If(Phase  =  'Future' And Commitment = 'Future', 3,
If(Phase  =  'Closed', 9
If(Match(Phase, 'Future', 'Delayed'), 8,
)))))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post