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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max Number, Others and Sub-Totals

Hi All,

This is a slight variation to the the post by Nigel West (http://community.qlik.com/forums/p/21096/80926.aspx#80926).

I have a straight table in which i would like to display the top 10 Stock items by Value. Currently i've set up the straight table to show Stock Items by Total Value in descending order and set the max visible number to 10.

error loading image

My problems are:

1. I would like to see a sum of the top 10 in both expression columns. Currently I can see a total of ALL and a total of ALL that are not displayed (Others), I want to see what IS displayed.

2. I would like to add a row number to my chart, but when i use rowno(total), i experience the same problem as federico as seen here (http://community.qlik.com/forums/p/18012/70446.aspx#70446)

I would appreciate any help. Many thanks.

1 Reply
Not applicable
Author

Hi Matt,

see the attached example for help.

Merry Christmas!

Rainer