topic Re: Two "Others" block appear in Block Chart in QlikView

Two "Others" block appear in Block Chart

Tue, 04 Mar 2014 07:20:25 GMT

I am facing this very unique issue while implementing block charts. I see two "Others" block appear (not always)

The even more surprising part is that when I click on either of the "Others", the resulting block chart is the same.

I have used a single Dimension (Customer Name), that has more than 100 distinct values. I have restricted my Block chart to show only 25, using Dimension Limits.

You can see two "Others" blocks above. I am not sure if this is a bug in Qlikview. When I click either of the "Others", it drills down and I see the same output in either case.

Any guidance here would be much appreciated.

Thanks,

Sagar

Re: Two "Others" block appear in Block Chart

Tue, 04 Mar 2014 07:23:03 GMT

Does your Dimension Contain 'other' As Any name in it

Re: Two "Others" block appear in Block Chart

Tue, 04 Mar 2014 07:30:21 GMT

No, there is no Customer Name "Others".

Also, if that was the case then clicking that "Others" would have selected only that particular Customer Name.

I see the same output when I click either of the "Others" block.

Re: Two "Others" block appear in Block Chart

MK_QSL — Tue, 04 Mar 2014 07:36:07 GMT

Hope your are not using Calculated Dimension with if condition which will give you Others when condition not satisfied..

something as below...

IF(Aggr(Rank(SUM(Sales)),Item)<=10,Item,'Others')

Re: Two "Others" block appear in Block Chart

Tue, 04 Mar 2014 08:33:11 GMT

Nope. I am not using an If condition that would give me Others.

Re: Two "Others" block appear in Block Chart

Tue, 04 Mar 2014 13:35:42 GMT

Hi Sagar

If there are too many values, and the resulting blocks are too small, then qlikview groups them together into the "others" category that you can see.

The good news is that you can set what the limit is before it implements this new category.

Go into the chart properties -> presentation tab and on the top left is the "lower limit on block area" and "maximum number of blocks options"

Make these smaller to view more of your categories in the chart.

You can also label the "others" to a different name eg, "small volume suppliers" by changing the label for others option that is below.

NB: All this functionality also applies to pie charts.

Does this work?

Erica

Re: Two "Others" block appear in Block Chart

Anonymous — Tue, 04 Mar 2014 19:57:08 GMT

Erica,

I'm sure you got the reason right - one "Other" is created by the "Dimension Limits", another by the size limit of smaller blocks. But the problem is that after the "Dimension Limits" tab was introduced, there are no controls for the "lower limit on block area" and "maximum number of blocks options" anymore. Neither in pie charts.
If there is still an option, I don't know where it is. So far, this lack of controls feels like a bug in itself.

Regards,

Michael

Re: Two "Others" block appear in Block Chart

Wed, 05 Mar 2014 08:36:25 GMT

I am still on QV10,so that's probably why

*downloads 11.2 onto laptop*