qlikview line chart

[#1]

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?

[robert_mika]

look here on how to do it:

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

[tresB]

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.

[Anonymous · Accepted solution]

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

[#5]

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.

[#6]

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

[Anonymous]

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

These 4 are into QV.....

[Anonymous]

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