Line Chart with different style

[Anonymous]

Hello all,

I want to show a line chart into two style solid and dotted both in alternate way.

I tried to achieve same in Line Style property of Expression tab with If condition but it is doing for mentioned condition only.

But I want to make it follow at alternate level without any condition. Is it possible??

Example : Say I am having Year as dimension and Amount as Sales, now through line chart for year 2009-2010, it shud be a solid line then for 2010-2011 it shud be dotted line and so on...

Pls suggest.

Regards,

Balraj

[Anonymous]

Got It Federico,

Great effort!!!

But how I can achieve same result where I would be having 100+ customers instead of Year?

[fvelascog72]

You´re welcome,

I think you also can use:

if((Mod(Year,2))=0,'<S2>')

so you don´t have to specify the year.

[fvelascog72]

Hi,

You can create a flag filed with this customers in script.

[MayilVahanan]

Hi

Try like this

= if(WildMatch(Customers,'XX','YY','ZZ'), '<S2>')

[Anonymous]

How Flag will sort out this issue?

Creating flag for each customer? or Common flag?

[Anonymous]

Mayil,

Its manual work, which I don't want to do, and again defining for 100 or 1000 customers it would be too biggy as I have to write all the customer manually.

Any other possibility?

[fvelascog72]

Can you share with us a little example of what do you want to achive with those customers?

[Anonymous]

Federico,

Its about representation only. Attached snapshot..

Now assume I am having 100+customers and I want to represent it with the combination of Solid and Dotted line for every alternate customer.

In attached snapshot,

abc-abe - Solid Line

abe-edf - Dotted Line

edf-ghb - Solid Line

ghb-ghj - Dotted line

and so on...

like this......

[fvelascog72 · Accepted solution]

Hi,

Maybe something like attached file.

[Anonymous]

Almost done, need to check with large data volume.

Gud Job!!!