Limit only top 10 values

[Anonymous]

Guys,

Is it possible to write any set expression to restrict the values displayed in the straight table? If it is plz help...

[Anil_Babu_Samineni]

look here, Good response

in qlikview i want take top 10 salaries how to wright ?

[devarasu07]

Hi,

Try like this,

Calculated dimension (top 10 Sales rank by Product and salesman wise)

=if(aggr(RANK(SUm(Sales),4),[Product ID],[Salesman ID])<=10,aggr(RANK(SUm(Sales),4),[Product ID],[Salesman ID]))

Limit Top 10 Sales value in Set analysis:

SUM({<[Salesman ID] = {"=Rank(SUM(Sales),4)<=10"}>}Sales)

[vinieme12]

Example

Sum({<Customer = {"=Rank(Sum(Sales),1,1)<=10"}>} Sales)

[beck_bakytbek]

Hi Silva,

try this expression:

as calculated dimension:

if(aggr(Rank(Sum(Your Value)), YourFieled) <= 10, YourField, NULL()) and dont forget to supress the Zero-Values

as expression: Count(YourField)

i hope that helps

beck

[awhitfield]

Hi Siva,

you could also use Dimension limits too!.

Andy

[vinieme12]

Yes, but Sort Order largely affects what data is shown, check the app to see what I mean

[KishoreSuri]

Hi,

I'm using Trellis container with Dimension "=if(aggr(Rank($(vMeasure)), $(vDim1)) <= 10, $(vDim1), NULL())" ,where we have multiple measures and dimensions and Bar chart should reflect as per selections.

If we use the above the expression in Dimension, getting error as "ERROR IN EXPRESSION ')'EXPECTED " , but i didn't find any missed brackets. 

Please help us.

Thanks,

Kishore