Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

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/

 

 

 

Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Digital Support
Digital Support

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.