topic Re: qlikview line chart in QlikView

qlikview line chart

Thu, 26 Nov 2015 05:54:53 GMT

Hi Guys,

I have a line chart in which dimention is Country, date and expression is sales, i see sales by date for different country. in the chart legend Country name will be displayed. But when user take monochrome print , he wants to identify the lines for each country. For example dotted line for one country, thick line for another country etc. Is it possible in qlikview?

Re: qlikview line chart

robert_mika — Thu, 26 Nov 2015 06:08:14 GMT

look here on how to do it:

qlikblog.at/725/qliktip-24-linestyles-linecharts-differentiate-actual-planning-figures/

Re: qlikview line chart

tresB — Thu, 26 Nov 2015 06:13:28 GMT

Are you using line chart with two dimensions? Could you share a sample qvw? Generally, you won't be able to get different sorts of lines with a single expression.

Re: qlikview line chart

Anonymous — Thu, 26 Nov 2015 06:17:23 GMT

These are the various Line styles:

'<S1>' = Solid Line

'<S2>' = Dashed Line

'<S3>' = Etc....

See the attachment how to set these styles in line chart.

You can write a expression for line style like:

IF(CountryName='India', '<S1>' and so on as per your requirement.

Hope this will help!!

Re: qlikview line chart

Thu, 26 Nov 2015 06:36:21 GMT

Thanks everyone for the help, but i have this below expression in background color of lines

=if(Language='English',if(Chart_ToggleFilter2_English = 'Country' ,

if(Country='India',Num#('ff9ab963','(Hex)'),

if(Country='US',Num#('ffe98c4b','(Hex)'),

if(Country='UK',Num#('fffecb4e','(Hex)'),

if(Country='Japan',Num#('ffd1d0ce','(Hex)'),Num#('fff1494d','(Hex)'))))))

if(Chart_ToggleFilter2_Chinese = 'セグメント' ,

if(Country='India',Num#('ff9ab963','(Hex)'),

if(Country='US',Num#('ffe98c4b','(Hex)'),

if(Country='UK',Num#('fffecb4e','(Hex)'),

if(Country='Japan',Num#('ffd1d0ce','(Hex)'),Num#('fff1494d','(Hex)')))))))

in this i am trying to put <S1>, <S2> instead of colors in Line style. But not working . Could anyone help me on this.

Re: qlikview line chart

Thu, 26 Nov 2015 06:47:16 GMT

it works thanks, but how many different pattern are there? i need 5 patterns, S1 to S5 will work?

Re: qlikview line chart

Anonymous — Thu, 26 Nov 2015 06:49:09 GMT

<S1> – continous (default)
<S2> – dashed
<S3> – dotted
<S4> – dashed/dotted

These 4 are into QV.....

Re: qlikview line chart

Anonymous — Thu, 26 Nov 2015 06:49:59 GMT

Also, if you have got the answer, close this thread by selecting the correct answer