This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi, I created a bar chart with the Others expression. On the dimension limit tab I chose to show only the largest 3 values.
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?
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
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
Hi, unfortunately the second part of your advice does not work. Disabling 'Show Others' caused showing only top 3 values.
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)
Create inline table as like
load * inline [
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 )"
Take optionsfield in a filter
Condition is not working 😞