Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Blackadder2000
Contributor II
Contributor II

Average for current selection ignoring null

Hi,

I would like calculate the average for the current selection for a data column ignoring null values. The average result for the calculation should be placed on each row in the next column to the data column. Basically I would like to generate a general script that performed the same calculation as the Totals avg function on the top of the column.

Labels (1)
0 Replies