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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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:)