Help for a QlikView newbie....

[#1]

I'm trying to manipulate some data and having a little bit of trouble.  I currently have data with several columns, including region (Europe, Asia....etc), question and answer (1 through 5).

What I'm trying to do is get the average answer for all questions from a given region.  For instance, I want to get an average of the ansers for every question in our 'Europe' region.  Can anybody point me in the correct direction on how to do this?  I wanted to create a gauge chart to display the average, but having issues just getting started.

Thanks in advance,

Tim

[#2 · Accepted solution]

OK - so you are looking to have multiple gauges, one for each continent?

You can add the continent to the set analysis like so:

    count({<Answer = {'Satisfied'},Continent = {'Asia'}>}Distinct Question)

    /

    count({<Continent = {'Asia'}>}Distinct Question)

As an alternative, you can simply use "count({<answer = {'Satisfied'}>}Distinct Question) / count(Distinct Question)" I suggested in a heavily formatted bar chart.  See Attached !

[#3]

Thanks, David!

I'm now at least getting the gauge to show up, which is great.  I think I have to tinker around with the expression to get it correct (as it's currently giving me 0 as the answer).  One (hopefully) last question -- Should I need to add the Region={'Asia'} to the "count(Distinct Question)" part to ensure that I'm only counting the total number of questions that were sent to the Asia region?

Thanks,

Tim

[#4]

Hi Tim,

Yes, you need to reduce the ‘set’ of the total to reflect only Asia.

David Freschl