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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Value in the Others Row

Hi Folks

Hope somebody can help me with this, I have a table as per attached picture which is selecting the top x number of values using the Max Number feature in the Presentation tab. I have also switched on the Show Others Row in the same tab.

The problem, as you can see, is that the Others Row is always empty.

How do I get values to appear in that row?

Cheers,

6 Replies
tseebach
Partner - Creator III
Partner - Creator III

Hi Nigel,

On the expressions tab, set the total mode to f.ex. to sum that will show a value in the others fields.

Not applicable
Author

f.ex. ? in english?

Not applicable
Author

Hi Matt

I'm also not sure what F.EX refers to, but it must have something to do with the Total Mode in the expressions tab (but in a different language), in the english version I set the total mode to Sum using the bottom check box as follows:

tseebach
Partner - Creator III
Partner - Creator III

Hi, sorry, f.ex. is short for "for example"

Cheers

Not applicable
Author

OK, great.

I did the same and achieved the same result.

Thanks for the clarification.

Not applicable
Author

Thanks Torben:)