topic Re: Top 10 required in QlikView

Top 10 required

Fri, 24 Jan 2014 05:24:19 GMT

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

Re: Top 10 required

Fri, 24 Jan 2014 06:10:56 GMT

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

Re: Top 10 required

Fri, 24 Jan 2014 09:57:48 GMT

Hey,

Go through the below thread.

TOP 10 and Bottom 10 Customer by Revenue Amount

Re: Top 10 required

Mon, 27 Jan 2014 06:59:37 GMT

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

Re: Top 10 required

Mon, 27 Jan 2014 07:08:06 GMT

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

Re: Top 10 required

Tue, 28 Jan 2014 09:27:51 GMT

Used “Gysbert Wassenaar” reply from below link

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

Re: Top 10 required

Tue, 28 Jan 2014 14:32:34 GMT

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?