topic Top 3 Averages in QlikView

Top 3 Averages

Mon, 02 Apr 2012 12:22:45 GMT

Hey could someone help me with an issue i have got,

I have 7 feilds :

ResponseID,

Region,

LotusNotes,

SAP R/3,

MSOffice,

VPN,

VideoConferening,

Where LotusNotes,SAP R/3,MSOffice,VPN and VideoConferencing are applications which are rated from 1-10.

ResponseID is an ID given to each individual that has rated an application.

Region relates to where the individual is from.

I need the applications to be sorted by top 3 averages , but then if the filter Region was selected it would change the averages according to that Region.

Top 3 Averages

CELAMBARASAN — Mon, 02 Apr 2012 12:26:12 GMT

Hi,

What do you mean top 3 averages here?

Celambarasan

Top 3 Averages

Mon, 02 Apr 2012 12:28:56 GMT

As in i need the averages for each application , and then for them to be sorted with only the highest three averages showing

Top 3 Averages

CELAMBARASAN — Mon, 02 Apr 2012 12:33:48 GMT

Hi,

You mean in each region for each application?or averages across application for each response id?

celambarasan

Top 3 Averages

Mon, 02 Apr 2012 12:35:41 GMT

Yeah so if a region was selected the averages would change on each application according to the region they are in

Re: Top 3 Averages

Clever_Anjos — Mon, 02 Apr 2012 13:11:58 GMT

0) Crosstable your data

1) Create a Simple Table Chart with your dim/expressions
2) Sort it by your expression (Sort Tab)
3) Show only 3 rows (Presentation Tab)

Top 3 Averages

Mon, 02 Apr 2012 13:55:43 GMT

Thank you this really helps - also is there a way to format this such that any application that has less than 5 responses is ignored?

Top 3 Averages

Clever_Anjos — Mon, 02 Apr 2012 13:58:35 GMT

Yes,
use

if(count(ResponseID) < 5,0,avg(Dados))

as your expression a "supress zeros" (Presentation Tab)

Top 3 Averages

Mon, 02 Apr 2012 14:04:46 GMT

thank you works like a dream