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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

Line Chart

hi,

i have a line chart of trend of TASKS

i want that the color of each line will be according to another dimnsion.

for ex-

each line represent a task

and i want that the color of the line will be according to the project that the task in.

how can i do that??

adi

9 Replies
ankit777
Specialist
Specialist

Hi,

U can add project in dimension then.

Anonymous
Not applicable

goto Expression of each line and define backgorund colour

if Project=1, red,

  if Project=2, green

...

insetad Projekt use your Dimension name

manojkulkarni
Partner - Specialist II
Partner - Specialist II

can you upload sample file or atleast sample data

amit_saini
Master III
Master III

Adi,

You can do something like below @ script side :

set vColorActDirectLabor = 'rgb(141,170,203)';

set vColorAOPDirectLabor = 'rgb(252,115,98)';

and later call these under expression'+'->background or text format.

Thanks,

AS

adiarnon
Creator III
Creator III
Author

TNX,

BUT I HAVE ALOT OF PROJECT AND THEY CHANGE

I NEED THAT IT WILL BE AOUTOMATIC.

ADI

adiarnon
Creator III
Creator III
Author

ITS NOT WORKING

awhitfield
Partner - Champion
Partner - Champion

Hi Adi,

can yu upload an example app?

Andy

ankit777
Specialist
Specialist

what are your current expression and dimension?

Please provide a sample application...

swarup_malli
Specialist
Specialist

Refer this thread