Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hello, I am looking to create table showing only the top 20 values of dimension

In my dimensions, I have sub groups by MT, NM, NV, then by Region T1, T2 , T3……T40

I want to create a table of totals grouped by

if Sub Group = NM then ‘NM Total’

then by the Top 20 Regions with all other listed as ‘Other Regions’ I have attached a spreadsheet for help.  Any suggestions are welcome.  Thank you!

2 Replies
Anonymous
Not applicable
Author

Hi Jennifer,

If I am understanding correctly, I believe you should be able to set a data limitation on your Regions dimension. To do this,

expand the drop-down menu on your Regions dimension > under "Limitations" select Fixed Number > choose "Top" > and in the formula bar put "21" (as this will display the top 20 plus a section for "others").

A simple option to display values for only sub group "NM" would be to use the measure:

     sum({<sub_group={'NM'}>}VALUE)

Please let me know if this helps!

Thanks,

Austin

Anonymous
Not applicable
Author

Thank you.  I had to change to a Straight table and create a couple of additional expressions, but I think this will work.

I appreciate the quick response!

Jennifer