topic line riferences on grid chart in QlikView

line riferences on grid chart

Mon, 13 May 2013 13:07:59 GMT

good mornig,

i have a grid chart with 3 dimension and one expression

the firts two dimension are: WEIGHT1 (Y Axes) ,WIEGHT2(X Axes) and WELD.

on the expression we have the Lenght of the WELD(that determines the size of the bubble)

The client ask me to add 2 line reference on X an Y Axes on '1' value

I put in presentation TAB the reference lines on X and Y '=1' but doesn't works.

seems put the line on the first line on the axis and not where the values of WEIGHT1 and WEIGHT2 are 1.

many thanks for your attention and best regards,

kinney

Re: line riferences on grid chart

Gysbert_Wassenaar — Mon, 13 May 2013 13:22:58 GMT

Try using a scatter chart instead of a grid chart. In the scatter chart you can place the reference lines like you want. In the grid chart it uses the order of the values, not the values themselves.

Re: line riferences on grid chart

Mon, 13 May 2013 13:40:18 GMT

Hi,

Try to put in Presentation tab two expressions in reference lines like X='1' for X-axis and Y='1' for Y-axis.

Hope this will help.

Best,

Yani

Re: line riferences on grid chart

Tue, 14 May 2013 07:17:57 GMT

yes, the scatter chart works!many thanks!

while, put 1 in presentation tab of grid chart unfoortunatly doesn't work.it's very strange.

is there someone can explain me this behavior.?

many thanks to all 🙂