Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Box and Whisker Plot in QV9

We are trying to create two Box and Whisker plot charts both plotting the QuestionnaireResponseFieldValue.Value field. The only difference is that the one on the left has a dimension of QuestionnaireResponseField.QuestionnaireName and the one of the right has a dimension of QuestionnaireResponseField.QuestionSetName.

When i step through the wizard and create the charts the charts don't seem to appear correctly. They show one out of four Questionnaires and two out of seven Question Set Names. The rest have zero values but this is incorrect as you can see in the table chart above the charts.

I've uploaded a .qvw file.

Anyone have any ideas???

3 Replies
danielrozental
Master II
Master II

I believe you are missing the field QuestionnaireResponseField.QuestionnaireName in the Aggr field list.

Attaching a file ins't working for me, try downloading the modified version from here

http://community.qlik.com/members/danielrozental/files/Supply-Chain2.qvw.aspx

Not applicable
Author

Thanks. I tried that some more and now i get things showing up correctly but i dont think the values themselves are correct.

If you use the chart iteself to lasso the 1.0 Develop Vision and Strategy the box and whisker is different from if you select that category in the table above...

i attached another file.

Not applicable
Author

Hi there

Thanks for the example, just what I needed.

Could I ask if it would be possible for you to update your model to show a second series of linked box plots, thus allowing me to compare two data ranges which have a common field. I would like to use it to compare our employees salaries against a market survey of their occupational groups' salaries according to the survey data.

As an alternative I thought that I can do a seperate graph and then place it on the first one transparently. The problem in this regard is that I cannot move the x-axes labels from the left side to the right side of the graph so that the two graphs x-axes values do not lie on top of each other.

Any help you can provide will be greatly appreciated, thank you!