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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bucketing Dimensions should always display

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

0 Replies