topic Re: 10 Smallest values on dimension limits in QlikView

10 Smallest values on dimension limits

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

I am trying to find the 10 smallest items in my expression.

Im using this in a straight table, could you advise why the 10 smallest value doesnt work, when I use the same expression to find the top 10 largest values it work, What can I do to get it to work

=num(pick(vDateView,

( sum({<FIN_YR_NO = {'$(vMaxFinYr)'}>} EXCELLENT)

(count({<FIN_YR_NO = {'$(vMaxFinYr)'},Response_Type={'Invalid Response'}>} MS2U_UCN)

count({<FIN_YR_NO = {'$(vMaxFinYr)'},Response_Type={'Valid Response'}>} MS2U_UCN)) ),

( sum({<YR_MTH_NO = {'$(vMaxYM)'}>} EXCELLENT)

(count({<YR_MTH_NO = {'$(vMaxYM)'},Response_Type={'Invalid Response'}>} MS2U_UCN)

count({<YR_MTH_NO = {'$(vMaxYM)'},Response_Type={'Valid Response'}>} MS2U_UCN)) )) , '#,##0.0%')

Thanks

Re: 10 Smallest values on dimension limits

Anil_Babu_Samineni — Wed, 03 May 2017 08:44:14 GMT

Don't take much pressure, Try with this from Dimension limit tab

Re: 10 Smallest values on dimension limits

rido1421 — Wed, 03 May 2017 08:50:30 GMT

Hi Anil

I have tried limiting it there, the report goes blank when I select 10 smallest...

Re: 10 Smallest values on dimension limits

Anil_Babu_Samineni — Wed, 03 May 2017 08:52:12 GMT

How is the values? Does values or looking percentage or simple digits? Can you show image or may be qvw?

Re: 10 Smallest values on dimension limits

rido1421 — Wed, 03 May 2017 09:01:11 GMT

It is percentages and im using names as a dimension in the table.

Unfortunately I cannot share the qvw, Im assuming it must have something to do with my expression

Re: 10 Smallest values on dimension limits

Anil_Babu_Samineni — Wed, 03 May 2017 09:06:07 GMT

In fact, Document is very helpful for us

May be this calculated dimension instead of your name

=if(aggr(rank(sum(MS2U_UCN)),Name)<=10,Name)

Re: 10 Smallest values on dimension limits

rido1421 — Wed, 03 May 2017 09:34:06 GMT

Hi Anil

Thank you for your assistance, I have tried using a calculated dimension its not working either.

I think the issue may be within my data I will have to try and build the chart a different way.

Re: 10 Smallest values on dimension limits

Anil_Babu_Samineni — Wed, 03 May 2017 09:36:47 GMT

That is the best option, Please upload sample so that we can look on that