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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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