Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agrimroquette
Valued Contributor

Color Expression

Hi,

i want help in coloring expression in qlik sense timeline master KPI,

my applied fx is-


=IF("Phase"= 'Project' or "Phase"= 'Opportunity' or "Phase"= 'Feasibility' or Commitment='On Schedule', 5 ,

IF("Phase"= 'Project' or "Phase"= 'Opportunity' or "Phase"= 'Feasibility' or Commitment='Delayed' or Commitment='Incomplete Info', 8 ,

IF("Phase"='Future' or "Commitment"='Future' , 4,

IF("Phase"='Closed' or "Commitment"='*' , 3,

IF("Phase"='De-Scoped'  or "Phase"= 'On-Hold' or "Commitment"='*' , 6

) ) ) ) )


but its not working properly, please refer attached .qvf if needed,

my desired output is as follows,

F=Feasibility, O=Opportunity, P=Project

Color Condition.PNG

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
6 Replies
agrimroquette
Valued Contributor

Re: Color Expression

i also tried,

=IF((Phase =  'Project' and Phase = 'Opportunity' and Phase = 'Feasibililty' and  Commitment = 'On Schedule'),  1,

If((Phase =  'Project' and Phase = 'Opportunity' and Phase = 'Feasibililty' and  Commitment = 'Delayed' and  Commitment = 'Incomplete Info'),  4,

if(  (Phase =  'Future' and Commitment= 'Delayed') , 8,

if(  (Phase  =  'Future' and Commitment = 'Future'),3,

if(  (Phase  =  'Closed' and Commitment = '*') , 9

)))))

but not working properly, please help,

Thanks & Regards

Ralf_Heukäufer
Contributor III

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.

agrimroquette
Valued Contributor

Re: Color Expression

Hi,

Can you suggest how?

Is my made expression is wrong?

Thanks

Ralf_Heukäufer
Contributor III

Re: Color Expression

In the Qlik Desktop:

looks:

agrimroquette
Valued Contributor

Re: Color Expression

Thanks for reply, can you check if my expression is correct or not??

=IF((Phase =  'Project' and Phase = 'Opportunity' and Phase = 'Feasibililty' and  Commitment = 'On Schedule'),  1,

If((Phase =  'Project' and Phase = 'Opportunity' and Phase = 'Feasibililty' and  Commitment = 'Delayed' and  Commitment = 'Incomplete Info'),  4,

if(  (Phase =  'Future' and Commitment= 'Delayed') , 8,

if(  (Phase  =  'Future' and Commitment = 'Future'),3,

if(  (Phase  =  'Closed' and Commitment = '*') , 9

)))))



According to below:-

Color Condition.PNG

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