Bucketing Dimensions should always display

Wed, 08 May 2013 10:35:53 GMT

Hi,

my bucket is:

NOT DUE

0-30

31-60

. and so on...

I am using below expression to display these buckets and I am using QV SR4.

=if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) < 0 ),Dual('Not Due',1),

If(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=0 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=30),dual('0-30',2),

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=31 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=60),dual('31-60',3),

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=61 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=90),Dual('61-90',4),

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=91 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=180),Dual('91-180',5),

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=181 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=365),dual('181-365',6),

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=365 and

(date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=670),dual('1yr - 2yr',7)

,dual('>2yr',8))))))))

For perticular selection my expression dont have data in "NOT DUE" bucket then it shows me all buckets except "NOT DUE" but I want to show all buckets every time, even if there is no data then I just want to display 0 with respect to that bucket.

If any one knows any method to do so then please share with me.

Regards,

Yojas

topic Bucketing Dimensions should always display in QlikView

Bucketing Dimensions should always display