topic Re: Hide Others when value is 0 in QlikView

Hide Others when value is 0

d_pranskus — Mon, 01 Sep 2014 15:40:44 GMT

I want to create a chart to show top 5 Dimension values and then Others. I set Dimension Limits to to 6 top values and enable Others check box. This works fine when there are transactions for 6 or more dimension values. But when there are 5 or less, it still shows the Other label.

I had already asked this once Hide "Others" when value is 0

Still no solution. Any ideas?

Many thanks.

Re: Hide Others when value is 0

MK_QSL — Mon, 01 Sep 2014 15:44:39 GMT

It should not show the others if there are transaction less than or equal to 5... Please provide your sample apps

Re: Hide Others when value is 0

israrkhan — Mon, 01 Sep 2014 17:21:06 GMT

I Think you have unchcked, select missing in presentation tab...

check both checkboxes, "Suppress Zero Value" and "suppress Missing" on presentation tab...

Re: Hide Others when value is 0

vijay_iitkgp — Mon, 01 Sep 2014 17:59:09 GMT

I think Manish is correct. I have It should not show when Total number of Dimension is less then Limit. But in case of Dimension having Null Values it will show Other also. I tried with Suppressing Null but still showing Other.