topic Re: Regarding Top 10 in Pivot in QlikView

Regarding Top 10 in Pivot

sarfaraz_sheikh — Wed, 14 Jan 2015 11:23:16 GMT

Dear All,

I used rank() in expression defination for calculating top 10...and i got that but how i can suppress other value in expression field other than top 10 in pivot table.

below is my expression :-

=if(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO))

Screeshot and QVW is also attached here for your reference

Kindly help !!!!

Regards

Sarfaraz

Re: Regarding Top 10 in Pivot

ashfaq_haseeb — Wed, 14 Jan 2015 11:28:49 GMT

Hi,

I don't find any such issue.

have a look at attached image and application

Regards

ASHFAQ

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Wed, 14 Jan 2015 12:06:17 GMT

Dear Ashpak,

I dont know why it is showing at my end.........anyway how i can suppress them any clue/solution/suggetion from your side

Sarfaraz

Re: Regarding Top 10 in Pivot

marchoctober — Wed, 14 Jan 2015 12:31:51 GMT

Hi!

Why don't you use Calculated Dimension? Calculate what do you want in it, so it should help.

Re: Regarding Top 10 in Pivot

Anonymous — Wed, 14 Jan 2015 16:29:15 GMT

Take a look at the attached file.

Is that what you are looking for?

Dennis.

Re: Regarding Top 10 in Pivot

richard_chilvers — Wed, 14 Jan 2015 16:43:21 GMT

I haven't looked at your issue in detail.

But do look at the Dimension Limits tab which can be useful to do Top n or Bottom n etc....

Re: Regarding Top 10 in Pivot

Anonymous — Wed, 14 Jan 2015 16:49:09 GMT

There is Dimension Limits tab in a pivot object I think.

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Thu, 15 Jan 2015 08:39:18 GMT

Dear Dennis,

once i click on the particular Disp_Catogory ...then it appears correct count order as top 10 but when i unclick the same then it appears in diffrent count..

Look on the snapshot below:---

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Thu, 15 Jan 2015 08:45:28 GMT

Dear Richard,

There is no Dimesion limit Tab in Pivot table ..........I checked in that

Sarfaraz

Re: Regarding Top 10 in Pivot

jzimolong — Thu, 15 Jan 2015 11:04:29 GMT

I'm struggling to figure out what your final desired output looks like. I came up with same thing as Dennis, using a calculated dimention for INTERMD_NAME, secondary to DISP_CATEGORY.

are you looking for final result like the attached?

Re: Regarding Top 10 in Pivot

Anonymous — Thu, 15 Jan 2015 14:52:54 GMT

I dont think your screenshot show the wrong numbers does it?

It just adjust the ranking to your selection. So if you select one INTERMD_NAME, it returns the top 10 rank of that selected INTERMD_NAME.

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Thu, 15 Jan 2015 14:57:04 GMT

Dear Joseph,

I am looking for output like below xlsheet...

Please have the loon on xlsheet

Sarfaraz

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Thu, 15 Jan 2015 15:00:48 GMT

Dear dennis,

So what i can do to achive the same .....I want to Show the output like above ...if am not selecting any category...then it should show the Top 10 as i want ....

Any suggestion\clue to rectify the same ...

Sarfaraz

Re: Regarding Top 10 in Pivot

Anonymous — Thu, 15 Jan 2015 15:57:10 GMT

I see what you mean, maybe the attached document is what you are looking for.

Dennis.

Re: Regarding Top 10 in Pivot

jzimolong — Thu, 15 Jan 2015 16:21:13 GMT

Hello. I opened the following thread, because I think I have your solution, but could not get the blank rows to be suppressed. Turns out it may be the version of Qlik I'm using. Anyway, take a look at this thread and see if any of the sample QVWs folks have posted work for your needs.

http://community.qlik.com/thread/148554

Re: Regarding Top 10 in Pivot

jzimolong — Thu, 15 Jan 2015 17:02:56 GMT

I upgraded to 11.2 SR7 and now suppressing rows for an expression works. I think the attached is close, but now I can't figure out how to SORT the expression, LOL.......

Re: Regarding Top 10 in Pivot

jzimolong — Fri, 16 Jan 2015 18:19:33 GMT

Last follow-up. Check out the following thread on how to get the sorting in proper order:

http://community.qlik.com/thread/148712

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Mon, 19 Jan 2015 05:08:51 GMT

Dear Dennis,

Thanks for your solution ....it works perfect as per expectation....Very nice..

Many Thanks

Sarfaraz

Re: Regarding Top 10 in Pivot

sarfaraz_sheikh — Mon, 19 Jan 2015 05:10:27 GMT

Thanks joseph for your reply........Many thanks due to your thread i learned new things in Qlikview...

Sarfaraz