Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

qlikview line chart

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?

Tags (1)
1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

Re: qlikview line chart

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

7 Replies

Re: qlikview line chart

look here on how to do it:

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

MVP
MVP

Re: qlikview line chart

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.

balrajahlawat
Esteemed Contributor

Re: qlikview line chart

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

Not applicable

Re: qlikview line chart

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.

Not applicable

Re: qlikview line chart

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

balrajahlawat
Esteemed Contributor

Re: qlikview line chart

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

These 4 are into QV.....

balrajahlawat
Esteemed Contributor

Re: qlikview line chart

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

Community Browser