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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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.

Labels (1)
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.