topic Re: Top N chart Help in QlikView

Top N chart Help

Anonymous — Sat, 06 Dec 2014 06:23:14 GMT

Hi All,

I need to create a dynamic Top N performance chart. I am having Owner as a Dim and Count(Service) as Exp.

So my exp like below

if(aggr(rank(Count(Service)),Owner) <=v_Rank, Owner, null())

The Variable needs to get input from end user.Here I what I am missing

Re: Top N chart Help

arulsettu — Sat, 06 Dec 2014 06:30:25 GMT

try this

=if(aggr(rank(Count(Service),3),Owner) <=v_Rank, Owner, null())

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 06:41:47 GMT

Hi Arul,

It is not working. Also here what 3 Ref?

Re: Top N chart Help

arulsettu — Sat, 06 Dec 2014 06:44:43 GMT

3 will return highest rank of all rows

can you post sample data source

Re: Top N chart Help

ecolomer — Sat, 06 Dec 2014 07:17:06 GMT

Try this:

=if(aggr(rank(Count(Service),3),Owner) <=$(v_Rank), Owner, null())

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 11:32:10 GMT

Hi Enrique,

Still it is not working. $ didn't helped me.

-Jay

Re: Top N chart Help

arulsettu — Sat, 06 Dec 2014 11:37:15 GMT

hey in rank function

Suppression of zero values is automatically disabled when these functions are used. NULL values are disregarded.

so why you using null()

Re: Re: Top N chart Help

ecolomer — Sat, 06 Dec 2014 11:38:17 GMT

For me is good, see this example

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 11:38:49 GMT

Hi Arul,

Due to data sensitivity, I cant share.Like I shown earlier post, it is simple data.

Re: Top N chart Help

alkesh_sharma — Sat, 06 Dec 2014 11:39:27 GMT

If you are not using a pivot chart, you can simply you can simply limit dimensions suing dimension limit tab.

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 11:44:02 GMT

Hi,

Enrique, I forget mention that I am using Bar chart. Will it make impact?And I need to have as a Expression. Not in calculated Dim.

Re: Top N chart Help

alkesh_sharma — Sat, 06 Dec 2014 11:47:33 GMT

In a bar chart you can simply use dimension limit, no need to go for rank functions and select the expression on basis of which you want to create TOP values.

Regards,

Alkesh

Re: Top N chart Help

arulsettu — Sat, 06 Dec 2014 11:47:39 GMT

have you tried by removing null

Re: Top N chart Help

ecolomer — Sat, 06 Dec 2014 11:48:22 GMT

You can use the same expression on bar chart, also

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 11:50:24 GMT

Hi Alkesh,

I can do that. But the limit should be dynamic. User will give run time values

Re: Top N chart Help

arulsettu — Sat, 06 Dec 2014 11:58:48 GMT

try like this

=if(aggr(rank(Count(Service),3)<=$(v_Rank)),Owner, null())

Re: Top N chart Help

Anonymous — Sat, 06 Dec 2014 12:09:11 GMT

Yes, I missed that simple step...

Re: Top N chart Help

alkesh_sharma — Mon, 08 Dec 2014 03:53:04 GMT

Yes you can do that, pass a variable in the limit tab, and give the user an input box.