Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AB
Contributor II
Contributor II
‎2019-09-24 09:52 AM

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)
TEST.qvw
88 KB
529 Views
0 Likes
2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
‎2019-09-24 08:27 PM

There you go:

clipboard_image_0.png

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

 

Refer qvw attached for reference.

 

Thanks and regards,

Arthur Fong

TEST (1).qvw
450 Views
Brett_Bleess
Former Employee
Former Employee
‎2019-10-02 05:51 PM

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

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.
429 Views
0 Likes