Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

QlikView average Value with nulls

Hi all, i'v a problem with average values in case of nulls... in the attached file there is a sample... I need to calculate the average in two ways: in the totals column, i need to use the selected months. in the monthly columns, use 1.. i hope anyone can help me!!

Labels (4)
2 Replies
Partner - Specialist III
Partner - Specialist III

There you go:


Use Dimensionality() and SecondDimensionality() to identify the hierarchy of the table.


Refer qvw attached for reference.


Thanks and regards,

Arthur Fong

Former Employee
Former Employee

Alessandro, did Arthur's post help you get things working as you desire?  If so, be sure to use the Accept as Solution button on his post to give him credit and mark the post as a working solution.  If you did something else, consider documenting that and mark that post, and if you are still working on things, leave us an update.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.