topic Re: Limit only top 10 values in QlikView

Limit only top 10 values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

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

Re: Limit only top 10 values

Anil_Babu_Samineni — Wed, 26 Apr 2017 10:48:52 GMT

look here, Good response

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

Re: Limit only top 10 values

devarasu07 — Wed, 26 Apr 2017 10:49:16 GMT

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)

Re: Limit only top 10 values

vinieme12 — Wed, 26 Apr 2017 10:58:16 GMT

Example

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

Re: Limit only top 10 values

beck_bakytbek — Wed, 26 Apr 2017 10:59:01 GMT

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

Re: Limit only top 10 values

awhitfield — Wed, 26 Apr 2017 11:06:38 GMT

Hi Siva,

you could also use Dimension limits too!.

Andy

Re: Limit only top 10 values

vinieme12 — Wed, 26 Apr 2017 11:19:38 GMT

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

Re: Limit only top 10 values

KishoreSuri — Wed, 07 Aug 2019 06:32:03 GMT

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