Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
robhagat
Contributor III
Contributor III

Customised line graph not showing the required color for line

Hi,

I am making a dashboard where one of my charts is a line graph showing 3 lines for different fields. I want the color of area of line to match with my other charts so trying to customize the colors of line but it is not working.

I am writing the following code in expression of line graph.

if(IsNum([Meters Instructed]),red(),

if(IsNum(Planned), LightBlue(),

if(IsNum(Completed),Green(),Yellow())))

Please find attached my input file for the chart. My X-axis has date and Y-axis shows 3 lines (Meter instructed, planned and completed column from input file).

Please suggest the way forward.

Regards,

Romila.

5 Replies
dilipranjith
Partner
Partner

Which version are you using. latest version has the option of setting colors for master measures. i.e.

each measure in your chart set as a master measure, assign the appropriate colot

robhagat
Contributor III
Contributor III
Author

Hi,

I am using Qlik sense desktop version 12.26.1.

Sorry but I am not able to see any master measures there. Please suggest.

Regards,

Romila.

dilipranjith
Partner
Partner

I meant add your measures e.g. Sum(Meters Instructed]) as a master measure and then assign a color.

not sure its available in 12.26 though. i am using september release

robhagat
Contributor III
Contributor III
Author

Ok, mine is June 2018 release.

I am adding 3 measures as sum(planned) etc and then trying to write expression in Colors and Legends.

Please let me know where do we get assign a color for master measures ?

dilipranjith
Partner
Partner

see below. not sure if its there in june 2018 though

Capture.PNG

if you cant upgrade see link below

Qlik Sense: How to set custom colors by measure in a bar chart