Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
jayati_shrivast
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
suganraj
New Contributor

Re: Ignore null values while calculaitng average

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