Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Matt
New Contributor III

Other values in bar chart

Hi, I created a bar chart with the Others expression. On the dimension limit tab I chose to show only the largest 3 values.

1.PNG

When I click on the Others now, I get again the largest 3 values (2 plus Others) and again, again..

All I wanted to show was the top 3 values (which I got),but when I click on Others I want to show all left values and not again top 3 (from the left). Is it possible to make it?

Thank you!

Labels (2)
8 Replies
Partner
Partner

Re: Other values in bar chart

hi,

it's not possbile, you can create two charts one with the top3 (uncomment show other) and the second with a function rank in the measure to show all without the top 3

Bye

Partner
Partner

Re: Other values in bar chart

Hi,

Can you please recheck the properties and also if possible can you change the value of 'Others' to some other name and test it and then filter for only Top 3 and also make sure you disable 'Show Others' checkbox 

Thanks

Santosh.

Matt
New Contributor III

Re: Other values in bar chart

Hi, unfortunately the second part of your advice does not work. Disabling 'Show Others' caused showing only top 3 values.

Partner
Partner

Re: Other values in bar chart

Hi,

I believe thats what you require right to show only the 3 values in the pie chart.

Thanks
Matt
New Contributor III

Re: Other values in bar chart

All I wanted to show was the top 3 values (which I GOT),but when I click on Others I want to show all left values and not again top 3 (from the left)

suganraj
New Contributor

Re: Other values in bar chart

Create inline table  as like 

A:

load * inline [

Optionsfield

Top 3

Others

];

Write a condition in the measure that 

if(getfieldselection(Optionsfield)='Top 3',"sum(condtion where you can exclude others )",

if(getfieldselection(Optionsfield)='Others',"sum(condition where you can exclude top3 )"

))

suganraj
New Contributor

Re: Other values in bar chart

Take optionsfield in a filter

Matt
New Contributor III

Re: Other values in bar chart

Condition is not working 😞