Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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