Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
538 results
Sorted by:
2012-12-05
10:11 AM
3 Likes
...bsp; . I need to calculate the top 10 values by cost in a pivot table. Can anyone help with this please. Regards, KV.
2014-02-10
03:53 AM
Hi all, I was just wondering if its possible to let a pivot table show me the top 10 best products I got. Now I am using the following dimensions: Productname: Year Month Expression: R...
2017-05-02
03:28 AM
Hello, I have a pivot table as mentioned below: ---------------Dimension-------------------------------- ------------------------E...
2019-02-07
04:51 AM
Bonjour, I am new to qlikView, I have a PivotTable and I want to show the first ten lines, I added this expression: =if((rank(sum({<Mouvement_ID={'VC'}>}Total_Net_HT))<=10), sum({&l...
2015-06-30
05:47 AM
Hi Frnz, Please help me. I would like display Top 10 values. But I am getting all values. Please find the attached QVW.
2015-01-14
06:23 AM
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 e...
- Tags:
- new_to_qlikview
2014-02-18
05:39 AM
Hello community, I'm trying to integrate a top X pivot table which only shows the top amounts based on the variable set for the limit. I know I have to use a calculated dimension with aggr a...
2015-04-13
02:11 PM
Hi Community Team, I have requirement like below I wanted to show top 10 countries by button I created a Pivot table in that dimension is Country and expression1 - sum(sales), e...
- Tags:
- new_to_qlikview
2011-09-29
12:29 PM
1 Like
...elect a Brand Coke or Pepsi then my Top 10 pivot table recalcuates the Top 10 for the Brand selection (which is what i want to show by default and not have to manually select a brand for a Top 10 by b...
Top 10 by brand example.qvw (163 KB)
Show results in replies (4)
-
It's parameters from the rank function to treat the equal item. How to calculate all ...
-
Miguel this worked great, for what does the 3 represent and what does the 1 represent?
-
...p a lot with in pivot tables so hopefully this can help someone else too. Kind r...
-
...s Null" to avoid results that are not in the top 10 showed with null "No" =If(Aggr(Rank(Aggr(S...
2018-02-02
05:15 AM
Hi Qlikers, Since i'm new I thought that this would be the best forum do ask questions. Issue: I want to show the Top 10 total in the pivot table. Just like in the picture below. But w...