topic Re: Line Chart in QlikView

Line Chart

adiarnon — Thu, 25 Jun 2015 07:13:06 GMT

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

Re: Line Chart

ankit777 — Thu, 25 Jun 2015 07:14:59 GMT

Hi,

U can add project in dimension then.

Re: Line Chart

Anonymous — Thu, 25 Jun 2015 07:16:37 GMT

goto Expression of each line and define backgorund colour

if Project=1, red,

if Project=2, green

...

insetad Projekt use your Dimension name

Re: Line Chart

manojkulkarni — Thu, 25 Jun 2015 07:20:37 GMT

can you upload sample file or atleast sample data

Re: Line Chart

amit_saini — Thu, 25 Jun 2015 07:35:18 GMT

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,

Re: Line Chart

adiarnon — Thu, 25 Jun 2015 08:52:25 GMT

TNX,

BUT I HAVE ALOT OF PROJECT AND THEY CHANGE

I NEED THAT IT WILL BE AOUTOMATIC.

ADI

Re: Line Chart

adiarnon — Thu, 25 Jun 2015 08:54:24 GMT

ITS NOT WORKING

Re: Line Chart

awhitfield — Thu, 25 Jun 2015 09:24:55 GMT

Hi Adi,

can yu upload an example app?

Andy

Re: Line Chart

ankit777 — Thu, 25 Jun 2015 09:59:13 GMT

what are your current expression and dimension?

Please provide a sample application...

Re: Line Chart

swarup_malli — Thu, 25 Jun 2015 13:01:22 GMT

Refer this thread