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

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

amita1621 — Wed, 11 Sep 2019 12:45:21 GMT

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!

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

Arthur_Fong — Thu, 12 Sep 2019 00:22:51 GMT

Is this the expected result?

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

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

amita1621 — Thu, 12 Sep 2019 05:34:14 GMT

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/

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

Arthur_Fong — Thu, 12 Sep 2019 05:53:34 GMT

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

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

amita1621 — Thu, 12 Sep 2019 06:17:03 GMT

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

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

Brett_Bleess — Tue, 24 Sep 2019 13:20:47 GMT

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