Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Bottom 10 results obtained through straight table and Bar chart differs

Hi all,

Sample data,

Company,Sales

66-A,1

10-B,0

11-A,0

20-B,5

13-B,2

17-A,3

81-S,4


We tried creating a bar chart as well straight table to list bottom 10 products.

In our bar chart when we displayed bottom 5 products the results were;

Company,Sales

10-A,0

11-A,0

66-A,1

13-B,2

17-A,3


Similarly when we change it to straight table to display the same, we got

Company,Sales

11-A,0

10-A,0

66-A,1

13-B,2

17-A,3

Kindly note that there is a change in order between bar and straight table. In bar chart 10-A,0 comes first and in straight its 11-A,0 which comes first. We have maintained sorting same for both straight as well as bra chart but, still we face the same trouble. is there any way in which we can have uniformity between these two.

with regards,

Shriram

2 Replies
MVP
MVP

Re: Bottom 10 results obtained through straight table and Bar chart differs

Could you share your sample qvw to investigate?

Or
Valued Contributor II

Re: Bottom 10 results obtained through straight table and Bar chart differs

Firstly, there's no 10-A in your dataset, so I'm assuming you mean 10-B.

Second, enabling Bottom 5 (in dimension limits) does not actually sort the data. The smallest values will be displayed, but the order in which they are displayed is still determined by the Sort tab.

Third, even without a default sort, I am getting the correctly-sorted values.

Is it possible you the chart and table using different sorting choices?