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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.