topic Re: Displaying Empty Buckets in QlikView

Displaying Empty Buckets

sasikanth — Tue, 05 Aug 2014 10:15:22 GMT

HI,

I have a requirement that i need to show the bucket ranges even though it do not have any values under the range

E.g :

Age

30 to 40

40 to 50

50 to 60

suppose there is no values under 50 to 60 Range then also i need to display all the values in my application

Can any one please give me the way how to achieve it

MK_QSL — Tue, 05 Aug 2014 10:25:25 GMT

Go to presentation tab and un tick suppress zero values

sasikanth — Tue, 05 Aug 2014 11:22:08 GMT

HI Manish Thanks for the reply

No Luck it is not working out ,

MK_QSL — Tue, 05 Aug 2014 11:29:29 GMT

Provide sample data.. pls

sushil353 — Tue, 05 Aug 2014 11:32:24 GMT

Hi,

Go through the attached document..

HTH

Sushil

sasikanth — Tue, 05 Aug 2014 14:41:49 GMT

Hi sushil

Thanks 4 ur reply

But Here i need to Show buckets based on the gien Range Not exactly about NULLs

if there is No data in that Range then how can we get that range to display in Application

giakoum — Tue, 05 Aug 2014 14:44:30 GMT

have you tried to uncheck suppress null values in the dimension tab?

mrybalko — Tue, 05 Aug 2014 14:57:33 GMT

Hello.

You need to generate buckets.Example is in attachment.