Ignore null values while calculaitng average

[jayati_shrivast]

Hi all,

I have a field as  Agent name and rating, I need to make a KPI as  average  agent rating  with agent name in filter pane.

but for some agent , under the rating field, the rating is null, i need to find the avg rating without considering null values.

The field values are as follows:

AGENT     RATING

JACK           4

JACK            5

JACK           

RON              3

RON             

RON              2..... and so on

How can I implement this. pls help me.

[tresesco]

Use avg() in qlik, it ignores nulls by default.

[Anonymous]

Try to use the condition in setanalysis like avg({<field-={''}>}value)