

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10 Smallest values on dimension limits
Hi
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't take much pressure, Try with this from Dimension limit tab


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Anil
I have tried limiting it there, the report goes blank when I select 10 smallest...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How is the values? Does values or looking percentage or simple digits? Can you show image or may be qvw?


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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is the best option, Please upload sample so that we can look on that
