topic Re: Line chart can have diffrent style of representation..!! in QlikView

Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Wed, 03 Sep 2014 10:57:17 GMT

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.

Re: Line chart can have diffrent style of representation..!!

vijay_iitkgp — Wed, 03 Sep 2014 11:15:32 GMT

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.

Re: Line chart can have diffrent style of representation..!!

avinashelite — Wed, 03 Sep 2014 11:27:49 GMT

Hi Rajveer,

Go to chart properties>style and choose the style you want.

If your looking for a specific style please provide the snapshot

Re: Line chart can have diffrent style of representation..!!

Gysbert_Wassenaar — Wed, 03 Sep 2014 11:39:52 GMT

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) & '>'

Re: Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Wed, 03 Sep 2014 12:48:09 GMT

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.

Re: Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Wed, 03 Sep 2014 12:53:33 GMT

this is the scenario :-

calculated dimension is

1. week

2. if(simtype='HIST', simtype, oreder count)

and the expression is:-

avg(ltsd);

Re: Line chart can have diffrent style of representation..!!

Gysbert_Wassenaar — Wed, 03 Sep 2014 12:54:04 GMT

Please show me how you manage to present one line from an expression and other lines from calculated dimensions in the same chart.

Re: Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Wed, 03 Sep 2014 12:58:54 GMT

please see this chart

Re: Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Wed, 03 Sep 2014 13:03:00 GMT

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.

Re: Line chart can have diffrent style of representation..!!

Anonymous — Wed, 03 Sep 2014 16:00:43 GMT

Rajveer

Maybe you need to go back to first principle and think about :

Why you have been asked to present the data ?
What insights are people hoping to gain from it ?

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.

Re: Line chart can have diffrent style of representation..!!

rajveersinghsisodiya — Thu, 04 Sep 2014 04:21:48 GMT

hi bill thanks for reply,

let me explain, that chart is default view of history and simulation . history has only one lineand others lines are of simulation, calculated based on different parameters,user can select those parameters. and if user select only one parameter then it will show one history and one simulation line and number of lines increases depends upon the selection of calculated simulation values by the user but the chart i have shown here it is default one in that all values of calculated simulation displayed.