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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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