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 for collaboration related to QlikView App Development.
i Have a Data as shown in below table
Sum(Sales) by Name is my straight table.
NOw i want to show top 10 sales.
Sow top 10 should be based on sales.Expected result(bottom Chart)
@marcus_sommer,@Oleg_Troyansky , @sunny_talwar,@rubenmarin ,
Hi @naveen341 ,
The solution you are seeking for sorting the data as per the ascending order with only the top 10 results can be found as below:
1. After creating a straight table, with Dimension as Names and Expression as sum(Sales). Go to Dimension Limit tab. On the left side, you will see your Dimension, Names selected.
2. There Check the box for 'Restrict which values are displayed using the first expression'. And select the first option with 'Show only'.
3. Select 'Largest' from the drop-down. And enter 10 in the next text box.
4. You can keep the Show others option from bottom options if you want to see remaining data.
5. Press Ok.
You will get your output as you expected. Let me know if you face any other issue.