Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

shashank20
New Contributor III

top 10 positive top 10 negative values in bar chart

Hi Genuises,

I am using the below formula as dimension and expression in chart

dimension :

=aggr(if(rank(num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)'))<=10

or rank(-num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)'))<=10,DESCRIPTION),DESCRIPTION)

Expression :

=num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)')

and in presentation Tab I am putting max visible number as 20 and checked so others label

Now the problem is when I have 10 positive and 10 negative values in chart Others will show

if lets say I have 10 positive and 5 negative values in chart then others are not showing instead it is clubbing everything as null "-" and displaying it

I want to show it as Others

Please please help I have to move this into production today

Thanks in Advance

Shashank

1 Reply
amit_saini
Honored Contributor III

Re: top 10 positive top 10 negative values in bar chart

Shashank,

Check if this help u:

https://community.qlik.com/message/782124#782124

Thanks,
AS

Community Browser