Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!!
look here on how to do it:
qlikblog.at/725/qliktip-24-linestyles-linecharts-differentiate-actual-planning-figures/
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.
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!!
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.
it works thanks, but how many different pattern are there? i need 5 patterns, S1 to S5 will work?
These 4 are into QV.....
Also, if you have got the answer, close this thread by selecting the correct answer