Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

amita1621
New 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!

4 Replies
Partner
Partner

Re: how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 express

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
New Contributor III

Re: how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 express

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/

 

 

 

Partner
Partner

Re: how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 express

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

amita1621
New Contributor III

Re: how to calculate top 10 in straight table and wit top 10 subtotal with 3 dimension and 3 express

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