Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use avg() in qlik, it ignores nulls by default.
Try to use the condition in setanalysis like avg({<field-={''}>}value)