Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Maya
Partner - Contributor II
Partner - Contributor II

Color Pie chart

Hi everyone,

I have a problem with pie chart color  and the property : Color (by Expression)

I have my Dimension:

=if([BLN.Baseline_Number]=1,

if(round([BLN.Finish_Date]-[BLN.Start_Date])=round([PRJ.Finish_Date]-[PRJ.Start_Date]) and date([BLN.Start_Date],'DD/MM/YYYY')<>date([PRJ.Start_Date],'DD/MM/YYYY'),'Décalage', if(round([BLN.Finish_Date]-[BLN.Start_Date])<>round([PRJ.Finish_Date]-[PRJ.Start_Date]),'En retard'))
,'Planning respecté')

 

My measure: (who count the number of project)

=count( {<[PRJ.Statut]={'Non commencé', 'En cours'}>} [PRJ.ID])

 

In ther property Color: by Expression

I put exactly the same formula as my dimension but with rgb color codes.

=if([BLN.Baseline_Number]=1,

if(round([BLN.Finish_Date]-[BLN.Start_Date])=round([PRJ.Finish_Date]-[PRJ.Start_Date]) and date([BLN.Start_Date],'DD/MM/YYYY')<>date([PRJ.Start_Date],'DD/MM/YYYY'), RGB(255, 255, 0),
if(round([BLN.Finish_Date]-[BLN.Start_Date])<>round([PRJ.Finish_Date]-[PRJ.Start_Date]),RGB(249,63,23))) 
,RGB(70, 198, 70))

 

but it seems my expression doesn't work.

pieChart.PNG

Can you help me please?

Thank you

0 Replies