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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Assigning colors to dimension created using value list

Hello All,

I created  pie chart using value list dimensions.

Dimensions:-=valuelist('Unlimited Contracts N-1','Fixed Term Contracts N-1','Total Temps N-1')

Right now the colors of the dimensions are coming automatically as i have opted Colors Auto in Qliksense

Aspiring_Developer_0-1601965672694.png

 I want to assign same colors to the dimensions like below:

Unlimited Contract N-1 = Blue 

Fixed term Contract N-1= Red

Total Temps N-1= Green

I tried to make assign the colors in measures like below but it did not worked .

=if( valuelist('Unlimited Contracts N-1','Fixed Term Contracts N-1','Total Temps N-1')='Unlimited Contracts N-1',

num(sum({<Indicateur.Code = {'PO.1.131b'},[Site.isYFPO]={'$(vChange)'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,Addmonths_Date={'$(= Date(addmonths(MonthStart(max(Addmonths_Date)),-11),'DD/MM/YYYY'))'} >} [Indicateur.Value])

/

sum({<Indicateur.Code = {'PO.1.137b'},[Site.isYFPO]={'$(vChange)'},[Site.Participe]={'49|50'},Date.Year = , Date.MonthName = , Date.Quarter =, Date.Month =, Date.MonthEnd =, MonthYear=,Date=,NewTestvb1=,Addmonths_Date={'$(= Date(addmonths(MonthStart(max(Addmonths_Date)),-11),'DD/MM/YYYY'))'} >} [Indicateur.Value])

,'###.#%', blue())

 

Can anyone please help me on this as i am not able to find anything on community ??

@Kushal_Chawda 

Labels (1)
10 Replies
Aspiring_Developer
Specialist
Specialist
Author

Can anyone please help me on this ? I am not able to find the solution . Please help 😞