Average in KPI

[xyz20]

Is there anyway to take average in KPI card and how to exclude null entries in KPI measure ??

[ggijben]

Hi, 

You could use something like

 AVG( {< Value = {"*"}>} Value)

so you'll only calculate the average of the rows which contain an actual value in column "Value".

[Qrishna]

By Default, the AVG() function in Qlik does not include null values. you dont need to do anything. but remember it also excludes the Dim field value from count that has corresponding null value while calculating the AVg. below is an example:

data:
load * inline [
Year, Sales
2024,500
2023,400
2022,
];

Notice how Avg() is automatically ignoring null value and its corresponding dim value.