topic Re: Displaying empty buckets in class function in QlikView

Displaying empty buckets in class function

Mon, 15 Jul 2013 09:50:05 GMT

Is there a method so that we can display buckets with value '0' in class function?

By default, it shows only those buckets having non zero values.

Thanks in advance!

Re: Displaying empty buckets in class function

swuehl — Mon, 15 Jul 2013 09:54:47 GMT

Have you used the class() function in the script? Then you can add a dimension table linked to this field containing all buckets. And then uncheck 'suppress zero values' in presentation tab.

Re: Displaying empty buckets in class function

Gysbert_Wassenaar — Mon, 15 Jul 2013 09:55:28 GMT

No. The class function doesn't create empy buckets.

Re: Displaying empty buckets in class function

Mon, 15 Jul 2013 09:57:40 GMT

Hi try this..

In dimension tab---

=If(Value='0',BucketsName)

In Presentation tab----

Uncheck Surpress Zero values

regards-bika

Re: Displaying empty buckets in class function

Mon, 15 Jul 2013 09:59:13 GMT

i used it as a calculated dimension.

The expression doesn't have any value for suppose '80-90' bucket, so this particular bucket is not displayed.

I want this empty bucket to be shown, although with a zero value. I haven't used'Suppress values when null'.

Re: Displaying empty buckets in class function

Mon, 15 Jul 2013 10:03:53 GMT

I have a calculated dimension with class function in dimension itself.