Qlikview 11 sample question

[#1]

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

[#2]

Option 1. Bar Chart

[#3]

Why 1 and why not the others ?

[#4]

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

[#5]

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

[#6]

It is available under Dimensions tab

Sent from my iPhone

[#7]

[MarcoWedel]

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

[jaimeaguilar]

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

[#10]

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