Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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.