topic Re: Excluding values in dimension in charts in QlikView

Excluding values in dimension in charts

Thu, 12 Sep 2013 11:20:33 GMT

I would like to exclude few values from the dimension in the chart, I am using if() statement, which is fine, however values which doesn't satisfy if() condition, comes as '-' separately. which is not required. Any workaround ?

Re: Excluding values in dimension in charts

Thu, 12 Sep 2013 11:24:48 GMT

You could use Only-statement to set which values are included

Re: Excluding values in dimension in charts

Thu, 12 Sep 2013 11:25:17 GMT

To hide the '-' values, you can click on "Supress When Value is Null" in properties, dimensions tab.

Hope it helps.

Re: Excluding values in dimension in charts

datanibbler — Thu, 12 Sep 2013 11:31:34 GMT

Hi Shyamal,

exactly. That's what I was about to say.

However, this checkbox "supress when ..." exists twice - once on the "dimension" tab and once on the "presentation" tab (in the dimension_area, in the bottom half).

You'll have to experiment a bit with those two.

HTH

Best regards,

DataNibbler

Re: Excluding values in dimension in charts

Thu, 12 Sep 2013 11:39:04 GMT

Yep!! forgot the presentation tab!

Thanks 🙂