Top 10 rows, Others do not show value

[Anonymous]

I have a straight table and in Presentation tab, selected 'Max Number' as 10 and also selected the 'Show Others Row'. I do not get values in the row labelled 'All Other'. What am I doing wrong?

Thanks,

Dinesh.

[Anonymous]

This problem goes away when I select 'Sum of Rows' in the expression tab instead of the default 'Expression Total'. Is this some sort of bug in V10? What is the difference between 'Expression Total' and 'Sum of Rows' anyway?

Thanks,

Dinesh.

[#3]

Hello,

The difference you might see would be for percentages.. if you do expression total for any percentage calculation, then it shows the individual percentages and the total for a whole of 100%, however you try the sum of rows then your percentage total could be like anything.. say 145% .. This is a best example as far as i think..

ANDY

[Anonymous]

Thanks for the pointer. Do you see the same problem like what I am seeing? Is this problem only in V10 or previous versions as well?

Regards,

Dinesh.

[neetu_singh]

Hi,

No this is not only in V10. this was also in V9.

[Miguel_Angel_Baeyens]

Hello Dinesh,

I don't see this as a problem rather than this is the expected behaviour of the straight table chart. Say your expression is

Sum(Value)

If you set a limit of the number of values you want to display, say 10, then the total mode is not the Sum(Value) for all possible values of the dimension (this would be the default). The total line, actually, keeps showing the Sum(Value) for all values in dimensions, not only the first 10 selected.

The "Others" is not a subtotal in itself, but the total sum of those values excluded by the max number. If "Total Mode" is set to "Sum of Rows" in conjunction with "Max Number" and "Show Others Row", then the value is as expected. Otherwise, the chart doesn't "know" what to show.

Hope that makes sense.

[Anonymous]

I would have to disagree that "Others" is not a sub-total. Why else would it honor the "Total Mode"? Besides it is automatically formatted bold as any Total row

When I select 'Expression Total', QlikView has all it needs to "know" what needs to be displayed. It does appear like a bug to me.

Regards,

Dinesh.

[Miguel_Angel_Baeyens]

Hello Dinesh,

Feel free to send an email to support@qliktech.com if that suits you.

Fortunately, the Reference Manual documents it:

Max NumberHere you can set the maximum number of rows to display. Rowsdisplaying sums are not counted; however, sums will still be calculatedusing all the rows of the table.Show Others RowThis option is available only if the number of displayed rows hasbeen limited (Max Number). Mark this check box to display a rowfor the surplus values. The Others row is calculated as a simple sumof the expression values of the rows omitted by the Max Number258Setting. The Others bar will thus only be meaningful for expressionswhere the Sum of Rows total is meaningful.

Hope that makes more sense now.

[Anonymous]

Thanks Miguel.

The reference manual actually supports my argument that it does seem like a bug. The others bar should have shown the 'Expression Total', in other words in my case same as 'Sum of Rows' as my expression is indeed sum(value).

Even if this was by design, it does seem counter-intuitive to me as one would have expected QlikView to show the sum and let the user decide if it was 'meaningful', instead of showing nothing.

Regards,

Dinesh.