topic Re: Scatter plot issue when using cyclic group drilling to single value in QlikView

Scatter plot issue when using cyclic group drilling to single value

nicktodd — Fri, 03 Jan 2014 16:19:46 GMT

I'm having a problem using a cyclic group in conjunction with a scatter chart.

In the example attached, showing student marks for a module (Y-Axis) against student average (X-axis) I've added a cyclic group so I can either show student year of birth or sex. This works well for modules M1 - M4 which have both male and female students marks.

For modules M5 and M6 only male students (E and F) took the module - now when I cycle the group to sex instead of seeing chart symbols for male the chart plots the student ID - which is not what I want (presumably, since sex doesn't change the chart shows the next dimension that does).

Also, once I have cycled to sex for modules M5 and M6 the cyclic group button disappears!

Any ideas how I can solve this problem and show sex correctly no matter which module I display?

many thanks

Nick

Re: Scatter plot issue when using cyclic group drilling to single value

Gysbert_Wassenaar — Fri, 03 Jan 2014 16:40:01 GMT

Well, you could uncheck the Suppress Zero-Values option on the Presentation tab. The drawback is the legend will show all values even if no data is actually plotted for that value.

Re: Scatter plot issue when using cyclic group drilling to single value

Anonymous — Fri, 03 Jan 2014 16:42:13 GMT

Nick,

See if the attached works for you.

Re: Scatter plot issue when using cyclic group drilling to single value

Clever_Anjos — Fri, 03 Jan 2014 17:26:54 GMT

Curious, how did you put that 45 degrees line?

Re: Scatter plot issue when using cyclic group drilling to single value

nicktodd — Fri, 03 Jan 2014 17:30:04 GMT

Michael

Thanks for your quick reply - that's perfect! I'm struggling to see what it is you did though.

Many thanks

Nick

Re: Scatter plot issue when using cyclic group drilling to single value

nicktodd — Fri, 03 Jan 2014 17:31:46 GMT

Clever

It's a kludge - all I did was create a line object then put the chart object on top of it (setting the background colour to be fully transparent) so the line object shows through.

Nick

Re: Scatter plot issue when using cyclic group drilling to single value

Clever_Anjos — Fri, 03 Jan 2014 17:34:26 GMT

nice, didn´t notice that

Re: Re: Scatter plot issue when using cyclic group drilling to single value

Anonymous — Fri, 03 Jan 2014 17:47:25 GMT

Nick, see the script. I added blank values for Sex. On the front end - used persistent colors, and changed third (blank sex) color to white. That means it is a problem in YOB mode. Changing it in the attached - color is conditional in 1st expression, and is white for the blank sex.

I think Gysbert's solution is better. First, it is simpler. Second, it doesn't affect anything else. My solution can affect other charts because I duplicate the rows. I didn't look at this.

Re: Scatter plot issue when using cyclic group drilling to single value

nicktodd — Fri, 03 Jan 2014 18:32:06 GMT

Gysbert

Thanks for this - so simple! In my real world example the value that my chart trips up on actually has quite a lot of possible values so it's not ideal to display them all in the legend when only one value is shown but it's a big improvement on what I have.

Nick

Re: Scatter plot issue when using cyclic group drilling to single value

nicktodd — Fri, 03 Jan 2014 18:33:56 GMT

Michael

Thanks again for your help.I think your solution will be OK for my real-world example.

Nick