Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

How to create greater than 30,45,90 and so on days in backend..

Hello everyone,

I want to show as a bucket field for greater than 30, 45 90 days and so on.

Please help me with this issue..

stalwar1‌ : Kindly look into this issue.

Regards,

Kavita

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

When you are creating buckets for greater than 30,45 and 90 days,

data which exist in 'greater than 40' bucket will also be present in 'greater than 30' bucket.

Ideally it will give wrong picture.

Is there any other criteria to consider while creating buckets?

kavita25
Partner - Specialist
Partner - Specialist
Author

Hi Shraddha,

Yeah I know that while creating buckets for greater than 30 or greater than 40 and so on will have the data present.

Also technically it will take the first condition, so that's my problem.

My requirement is if it is >30 it should give you from 31st day till the last day.

and for > 45 it should give you from 46th day till last day.

Hope you understand it.

Regards,

Kavita

sunny_talwar

May be like this

Fact

LOAD ....

FROM ....;

LinkTable:

LOAD Date,

     '> 30 Days' as Bucket

Resident Fact

Where Today() - Date > 30;

Concatenate (LinkTable)

LOAD Date,

     '>45 Days' as Bucket

Resident Fact

Where Today() - Date > 45;

...

and so on....