topic Qlikview 11 sample question in QlikView

Qlikview 11 sample question

Tue, 25 Mar 2014 21:50:12 GMT

Hi, I will be posting a series of sample questions for qlikview. Please help me to get the answers.

Thanks.

This is the first one.

A customer needs to compare sales results for nine countries over four years for two salespersons. Which Trellis Chart by country should a designer use?

Bar Charts by year by salesperson with grouped style

Pie Charts by year by salesperson with 3D style

Line Charts by year by salesperson with stacked, 3D style

Block Charts by year by salesperson with stacked style

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:28:11 GMT

Option 1. Bar Chart

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:36:24 GMT

Why 1 and why not the others ?

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:54:02 GMT

We get the Trellis option only on the 'Bar' charts.

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:57:50 GMT

Thanks. Where is the trellis option ? I tried to create a bar chart, but I could not find a trellis option in its settings.

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 23:01:19 GMT

It is available under Dimensions tab

Sent from my iPhone

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 23:18:30 GMT

Re: Qlikview 11 sample question

MarcoWedel — Tue, 25 Mar 2014 23:21:22 GMT

Hi John,

my favorites are bar charts and the grid chart for these cases.

For only two values in the salesperson dimension, you could color code the salesperson, e.g. like this:

my second favorit is the combo chart with stacked bars and a line that indicates the sales ration of one salesperson:

other charts I find inferior to these:

hope this helps

regards

Marco

Re: Qlikview 11 sample question

jaimeaguilar — Tue, 25 Mar 2014 23:25:59 GMT

Hi, I think most suitable answer is the first one. The ones that mention 3D I think that should be discarded because that visualization style tends to "distract" or alter proportions. And the block chart is almost never a good option over bars or lines. Trellis option is located in dimensions tab

For more data visualization references, read material from Stephen Few,

regards

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 23:32:40 GMT

Thanks to all for the answers ! I appreciate your help. Btw, where is the mark answer button now ?

Re: Re: Qlikview 11 sample question

MarcoWedel — Wed, 26 Mar 2014 00:50:09 GMT

another chart that better distincts between the different salespersons: