Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Ignore null values while calculaitng average

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.

 

2 Replies
Highlighted
MVP
MVP

Re: Ignore null values while calculaitng average

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

Highlighted
New Contributor

Re: Ignore null values while calculaitng average

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