How can I do Dot plot in style of minitab i.e. 1 dot for every occurance?

[#1]

I have a data set which I want to display as a dot plot in a similar way to minitab - there is just 1 axis (% saved) and each row in my data set represents a different case with a different % saving rounded to nearest full %. I want to show this in Qlikview but nearest I have gotten is via a Bar Chart which shows the right shape, but unable to get this to represent the bar as dots i.e. for each instance the value occurs (don't worry about the fact that minitab representing 3 occurances per dot - I just need 1 dot per occurance).

The example in minitab is attached (as is my attempt to do via bar chart) Please can you advise if this is possible - and if so what chart I should I be using/how?

[jvitantonio]

Hi Caroline,

I put together an example using a grid chart. For every % you have a value . That value will be graphed as a dot. You can then play with the scales.

I hope it helps.

JV

BI Experience | A place to share our Business Intelligence experiences

[#3]

Hi Q L - if I try doing a Grid chart it says too few dimensions (as i am only using rounded % saved). Is there a way to get around this?

[jvitantonio]

If you see my example, I put a 1 as expression , so you can do they same.

JV

http://biexperience.wordpress.com/

[Gysbert_Wassenaar]

A grid chart might work, but your bar chart is a far better solution. Why do you want the inferior visualisation?

[#6]

something my boss wants!!

[Gysbert_Wassenaar]

Educate him/her/it!!