Regarding Top 10 in Pivot

[sarfaraz_sheikh]

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

[Anonymous]

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.

[sarfaraz_sheikh]

Dear Joseph,

I am looking for output like below xlsheet...

Please have the loon on xlsheet

Sarfaraz

[sarfaraz_sheikh]

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

[Anonymous · Accepted solution]

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

Dennis.

[jzimolong]

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

[jzimolong]

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.......

[jzimolong]

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

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

[sarfaraz_sheikh]

Dear Dennis,

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

Many Thanks

Sarfaraz

[sarfaraz_sheikh]

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

Sarfaraz