topic Re: Scatter plot reference line in QlikView

Scatter plot reference line

Anonymous — Fri, 23 Dec 2016 17:43:19 GMT

Hello to all,

I would like to create a scatter plot graph with due measures on x-axis. So i added the two measures and the i used the group command in order to create a cycle selector. Then i would like to add a reference line (median) and i want also see on the graph the value next to the reference line. So i used the add reference line area in the presentation tab but i dont know how to show the valute of the median line of the first measures when i selected the first one with cycle selector and how to look the second one when i change it on the graph.

Anyone can help me with this issue?

Best regards

Andrea

Re: Scatter plot reference line

vishsaggi — Fri, 23 Dec 2016 17:53:59 GMT

Try this and let me know if this is what you looking for? Conditional show based on your selection.

Re: Scatter plot reference line

Anonymous — Fri, 23 Dec 2016 18:05:38 GMT

‌I Vishwarath and thank you for your answer. I would like to try what you suggest but i don't understand what i nave to put as measure in my expression. So i have measure 1 and measure 2 and i want to calc the median. So in the label space i have to write the calculation of what? --> median(?????)

Re: Scatter plot reference line

vishsaggi — Fri, 23 Dec 2016 19:30:19 GMT

Yes, where ever you want the line to be and the label. I mean in the label and in the expression where you see the GreenRef, write your median expression. let me know if i have not quite understood your requirement. If i did not can you share a sample app or a snapshot of your output.

Re: Scatter plot reference line

Anonymous — Tue, 27 Dec 2016 08:57:01 GMT

I Vishwarath sorry for the delay. I tryed to create an example, in which you will find a scatter plot graph with median for the y-axis and a cycle group for the x-axis. I would like to have a median for the x-axis that change whenever change the x-measure.

Re: Scatter plot reference line

vishsaggi — Tue, 27 Dec 2016 14:51:12 GMT

Can you share a sample if possible ?

Re: Scatter plot reference line

Anonymous — Tue, 27 Dec 2016 14:56:10 GMT

I sent to you via email the sample file. Is there a way to share it directly here?

Re: Scatter plot reference line

sunny_talwar — Tue, 27 Dec 2016 15:03:32 GMT

Uploading a Sample

Re: Scatter plot reference line

Anonymous — Tue, 27 Dec 2016 15:26:49 GMT

Thanks Sunny

Re: Scatter plot reference line

vishsaggi — Tue, 27 Dec 2016 19:49:34 GMT

Thanks Andrea, will look into it and get back.

Re: Scatter plot reference line

vishsaggi — Tue, 27 Dec 2016 20:24:13 GMT

It is kind of tricky to use the cyclic expressions to be rendered based on selections. I could able to add two median lines in X axis but hide and show using cyclic group expression, is where it is becoming trickier. May be someone else could help here?

Re: Scatter plot reference line

sunny_talwar — Tue, 27 Dec 2016 20:35:32 GMT

May be fool your users into believing that they are using a cycle group, but use a button to toggle between the two expressions?

Re: Scatter plot reference line

vishsaggi — Tue, 27 Dec 2016 20:41:13 GMT

Thanks Sunny, Could not think of that, was just thinking to get the Cyclic Group. Absolutely smart. 🙂

Re: Scatter plot reference line

sunny_talwar — Tue, 27 Dec 2016 20:43:59 GMT

Its a stupid work-around which may or may not work.... but just thought of suggesting just in case it might help

Re: Scatter plot reference line

vishsaggi — Tue, 27 Dec 2016 20:46:11 GMT

Naaa, it is definitely a smart work around because i doubt if we have any function to get the Expression level cyclic group names to work on. Probably this is the best way of showing those reference lines.

Re: Scatter plot reference line

Anonymous — Wed, 28 Dec 2016 10:06:46 GMT

Thanks Vishwarath and Sunny for your advice. I will try this solution