topic Re: Line Chart with different style in QlikView

Line Chart with different style

Anonymous — Mon, 15 Jun 2015 10:24:33 GMT

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

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 10:35:59 GMT

Hi,

In Expressions Tab you can use in Line Style: if(Year=2010,'<S2>')

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 10:36:02 GMT

Sunny,

Two expression means, two different line?

But I want to do it in a single line with a single expression...

Re: Line Chart with different style

sunny_talwar — Mon, 15 Jun 2015 10:36:02 GMT

You want some like this??

If yes, PFA

Best,

Sunny

Re: Line Chart with different style

sunny_talwar — Mon, 15 Jun 2015 10:37:55 GMT

Did not think of this method. I think this is the answer you are looking for.

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 10:38:52 GMT

No,

It should be in a alternate way...

As per your Year Dimension, 2010-2011 is a dotted, then it should repeat for 2012-2013 and then 2014-2015 so on...

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 10:42:49 GMT

Try:

if(Year=2010 or Year =2012 or Year= 2014,'<S2>')

Re: Line Chart with different style

avinashelite — Mon, 15 Jun 2015 10:45:58 GMT

try this:

if(Even(Year)=-1,'<S3>')

Re: Line Chart with different style

sunny_talwar — Mon, 15 Jun 2015 10:46:12 GMT

Works perfectly Federico Velasco‌. Balraj Ahlawat‌ this gives exactly what you seems to be looking for:

Great job Federico, thanks for showing us this.

Best,

Sunny

Re: Line Chart with different style

avinashelite — Mon, 15 Jun 2015 10:54:46 GMT

@fvelascog72 good work

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 10:55:31 GMT

Got It Federico,

Great effort!!!

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

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 10:56:11 GMT

You´re welcome,

I think you also can use:

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

so you don´t have to specify the year.

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 10:58:21 GMT

Hi,

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

Re: Line Chart with different style

MayilVahanan — Mon, 15 Jun 2015 10:58:24 GMT

Try like this

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

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 11:06:53 GMT

How Flag will sort out this issue?

Creating flag for each customer? or Common flag?

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 11:10:08 GMT

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?

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 11:12:00 GMT

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

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 11:19:57 GMT

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......

Re: Line Chart with different style

fvelascog72 — Mon, 15 Jun 2015 11:39:45 GMT

Hi,

Maybe something like attached file.

Re: Line Chart with different style

Anonymous — Mon, 15 Jun 2015 12:03:02 GMT

Almost done, need to check with large data volume.

Gud Job!!!