
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Regarding Top 10 in Pivot
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
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I see what you mean, maybe the attached document is what you are looking for.
Dennis.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I don't find any such issue.
have a look at attached image and application
Regards
ASHFAQ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
Why don't you use Calculated Dimension? Calculate what do you want in it, so it should help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take a look at the attached file.
Is that what you are looking for?
Dennis.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is Dimension Limits tab in a pivot object I think.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:---

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Richard,
There is no Dimesion limit Tab in Pivot table ..........I checked in that
Sarfaraz


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- « Previous Replies
-
- 1
- 2
- Next Replies »