topic Re: date bucket script error in QlikView

date bucket script error

didierodayo — Thu, 02 Feb 2017 05:38:11 GMT

Hello,

I have 2 date fields and am trying to create a date bucket out of both.

I want the bucket to reflect

passed date - 'Now'

Today() and next 3months - '3m'
passed and next 3months - '0-3m'
3month to 6months -6m
passed and next 6months - '0-6m'

6months to 12 months - 12m
passed and next 12months - '0-12m'

12 months to 24 months - 24m
passed and next 24months - '0-24m'

24months to 36 months - 36m
passed and next 36months - '0-36m'

what will be the best way to achieve this giving I have to date fields to sort through?

I have attached a qlikview with my current method which is not working.

Re: date bucket script error

dsharmaqv — Thu, 02 Feb 2017 09:46:52 GMT

try this

How Do I Get the Number of Months Between Two Dates?

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 10:07:39 GMT

Why do you say it is not working? I mean I see a Bucket field, what is wrong with it?

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 10:18:17 GMT

Hi Sunny,

first it is not returning the options '0-3m' ; '0-6m' etc..

also on the table objects the buckets are not showing next to the dates.

Thanks for your assistance.

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 10:21:37 GMT

0-3 and 0-6? So 0-6 will include 0-3 also?

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 10:35:57 GMT

Yes '0-3' will include passed up to next 3months

'0-6' will include passed up to next 6 months

'0-12' passed up to next 12 months

etc..

is it possible to have this together with in the same bucket (field) as the 3m, 6m, etc..?

what will be the best way in this scenario?

best regards

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 10:38:15 GMT

I don't think if statement will work in that case.... you will have to concatenate using where statement. Look here for a similar thing:

Re: group number by range

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 10:48:15 GMT

Thanks Sunny I will try and confirm shortly.

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 11:18:20 GMT

Hi Sunny I have applied the method above but the '0-3' etc.. are still not coming across for some reason. I have attached the doc below.

Thanks

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 11:58:36 GMT

This seems to be the same document as before. Did you attach the wrong qvw?

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 12:03:15 GMT

yes wrong doc . sorry. I have attached the correct ne now

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 12:09:34 GMT

Can you run the attached

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 12:16:11 GMT

They are loading up but the result is incorrect.

Re: date bucket script error

sunny_talwar — Thu, 02 Feb 2017 12:30:35 GMT

Check out now

Re: date bucket script error

didierodayo — Thu, 02 Feb 2017 12:44:50 GMT

That once again Sunny your help is always appreciated. It is working now. Cheers