Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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!!

2 Replies

Re: QlikView average Value with nulls

There you go:


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


Refer qvw attached for reference.


Thanks and regards,

Arthur Fong

Digital Support
Digital Support

Re: QlikView average Value with nulls

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.