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: 
Anonymous
Not applicable

Mean in Total Mode

Mean is not available in drop down of "Total Mode" in Straight table \ Expressions. Is there any work around?

Thanks,

Dinesh.

4 Replies
Miguel_Angel_Baeyens

Hello Dinesh,

Have you tried "Average"? Is that what you expect?

Anonymous
Not applicable
Author

I misspoke. I was looking for median as average misleads when there are outliars. Thoughts?

danielrozental
Master II
Master II

How about Fractile(total FIELD, 0.5)

Anonymous
Not applicable
Author

That is a good thought. Thanks. I guess I can make it simpler by using median(total fielda). The disadvantage is that I want to see the actual value of fielda, but the median in the total line.

Thoughts?

Dinesh.