Top 10 required

[#1]

Dear Gurus,

I have an urgent requirement. Attached the sample data and qvw

I am able to achieve Top 10 in Table 1 for HR, but same thing in Table 2 I need to achieve but expression should be grouped.

So when user select cyclic group “User” and expression Cyclic group “TV”  in table 2 attached TV should be the result

So when user select cyclic group “User” and expression Cyclic group “TC”  in table 2 attached TC should be the result

So when user select cyclic group “User” and expression Cyclic group “HR”  in table 2 attached HR should be the result

Thanks in advance and please do let me know in case of any clarification

[#2]

Can you please check the attachment. If it meets the requirement, then I can explain how I did it.

[#3]

Hey,

Go through the below thread.

TOP 10 and Bottom 10 Customer by Revenue Amount

[#4]

Hi Angad,

Thanks for your reply but attachement is not what i required, we cannot have Top 10 for Nov 2013 itself we have Dec and Jan

[#5]

Did you try clearing the selection, current in my attachment it is selected as Nov 2013.?

[#6 · Accepted solution]

Used “Gysbert Wassenaar” reply from below link

http://community.qlik.com/message/401046#401046

[#7]

I was unable to do this on dashboard.let me share one xsl file.In that i wanna calculate top sales of product.I used dimension as product in Bar chart and i used the expression as =if(aggr(rank(sum(sales)),product)<=5,product).It is showing no data found.If that is the case i deleted that expression did sum(sales).And in dimension limit i used show largest 5 values.It is showing only 4 products values and 5th is other.What about the 5th product.I need to get that 5th product even.We need to go for exactly the finite number of choice then that is the case what is the solution.In this case i have go with that expression.But its not working.

Can any one please tell me the steps how can i solve this problem?