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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average of '0' results in dimension not being displayed

Hi,

Can somebody help me out?

I want to view the average of 'total time' per 'month year' dimension.

Now, this seems to work just fine, except when all the values for a dimension row are 0.

In that case it looks like the dimension row is not displayed at all, while the outcome should be 'the average is of al the 0 rows is 0'.

avg.png

What is displayed is entirely correct, but I want to see the '2015-Mar' with value '0' row as well.

In fact, in the end I want to see this in a graphical chart, but I tried to get the solution first with the tabular chart.

An example attached.

Regards,

Maarten

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Maarten,

uncheck in tab Grafic

Img11.png

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi Maarten,

uncheck in tab Grafic

Img11.png

Regards,

Antonio

Not applicable
Author

Thanks a lot Antonio! That seems to do the job just fine!!

Have a nice day!