Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying empty buckets in class function

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!

5 Replies
swuehl
MVP
MVP

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.

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

Hi try this..

In dimension tab--- 

=If(Value='0',BucketsName)

In Presentation tab----

Uncheck Surpress Zero values

regards-bika

Not applicable
Author

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'.

Not applicable
Author

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