topic Re: QlikView average Value with nulls in QlikView

QlikView average Value with nulls

AB — Sat, 16 Nov 2024 02:24:16 GMT

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!!

Re: QlikView average Value with nulls

Arthur_Fong — Wed, 25 Sep 2019 00:27:54 GMT

There you go:

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

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

Re: QlikView average Value with nulls

Brett_Bleess — Wed, 02 Oct 2019 21:51:11 GMT

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.

Regards,
Brett