Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i am using line chart with two dimensions first one is week and other is calculated dimension and one expression.
line chart has diffrent 10 to 15 lines based on calculated dimension,
Each line has diffrent color,but i need diffrent color with diffrent style for each line displayed.
The are only four different line styles possible. You can change the line style by clicking on the + in front of the expression, select Line Style and enter '<S1>' as expression. S1, S2, S3 and S4 are valid line styles. You can also change the thickness of the line with <W1> through <W8>.
If you want to make the line style depend on the dimension value you'll need something like
'<S' & FieldIndex('MyDimension', MyDimension) & '>'
Hi Rajveer,
What do you mean my different style? You can check Symbol checkbox in Expression tab and also change style of line from normal to Smooth or anything else as given in dropdown.
Hi Rajveer,
Go to chart properties>style and choose the style you want.
If your looking for a specific style please provide the snapshot
The are only four different line styles possible. You can change the line style by clicking on the + in front of the expression, select Line Style and enter '<S1>' as expression. S1, S2, S3 and S4 are valid line styles. You can also change the thickness of the line with <W1> through <W8>.
If you want to make the line style depend on the dimension value you'll need something like
'<S' & FieldIndex('MyDimension', MyDimension) & '>'
hi Gysbert Wassenaar thans for reply but in my chart only one line coming from expression and other lines are coming directly from calculated dimension so where i can write above mentioned expression for line style.
this is the scenario :-
calculated dimension is
1. week
2. if(simtype='HIST', simtype, oreder count)
and the expression is:-
avg(ltsd);
Please show me how you manage to present one line from an expression and other lines from calculated dimensions in the same chart.
please see this chart
i am new to qlikview so not able to write technical words but may be you can understand by that graph and the dimensions and the expresion provided.
Rajveer
Maybe you need to go back to first principle and think about :
10+ lines on a single chart is never going to be easy for a human brain to visualise, in fact for me looking at your images I find it impossible.
You may find it better to use a different visualization.