Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
amita1621
Contributor III
Contributor III

how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 expression

Hoping someone can help. I have a Straight table with the displayed values limited to the Top 10. What I'd like to calculate is the sub-total for that Top 10. I also need to subtotal the entire data.

 

Does anyone have any ideas?

 

Much appreciated!

5 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Is this the expected result?

clipboard_image_0.png

In chart properties > presentation > check "Max Number".

Expression for top 10 :

avg({<[Student Id] ={"=Rank(avg(marks))<=11 "}>} marks)

Refer attached qvw for reference.

 

Thanks and regards,

Arthur Fong

amita1621
Contributor III
Contributor III
Author

Hi,

Thanks for the response but I am expecting something different.

I have 3 dimension and 3 expressions. Now on 1st dimension, I need top 10 records and display the sum of top 10 and Others and also the total amount. And also need to sort on one of the expression/

 

 

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Maybe you can provide a sample qvw and your expected output?

amita1621
Contributor III
Contributor III
Author

I need in this format.I have given top 5 data.

Brett_Bleess
Former Employee
Former Employee

Amita, in this situation, it is most likely going to require that you post a sample app with your data model and chart with expressions etc.  It does not have to be the full set of data, but enough that folks will be able to see how the data model is setup and what you are doing with the expressions.  Not sure you are going to get what you need otherwise on this one, as it is a bit difficult to follow without being able to see the other detail.  Just wanted to try to move things forward for you.  If you have some confidential fields, you can use the Settings\Document Properties\Scrambling tab to scramble those, but if any of those fields are being used in your expressions, that may prove problematic as well.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.