topic Re: Month as Bucket in QlikView

Month as Bucket

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am having a month from May 2017,Jun 2017,Jul 2017.....Dec 2021. Here I need to have filter to classify these month values.

Ex:

+3 Months = From May 2017 to Jul 2017

+6 Months = Aug 2017 to Jan 2018

+12 Months = Feb 2018 to Rest

Let me know with your ideas

-Jai

Re: Month as Bucket

Anonymous — Thu, 11 May 2017 08:22:23 GMT

Have a look:

Date bucket from date fields

Re: Month as Bucket

Anonymous — Thu, 11 May 2017 08:32:10 GMT

Hi Anil,

Here my requirement is based on month filter (+3months,+6Months,+12Months) my data needs to get changed

Also I dont have date field here. Based on Month Name (May 2017,Jun 2017....) I need to get filter.

-Jai

Re: Month as Bucket

Anil_Babu_Samineni — Thu, 11 May 2017 08:58:21 GMT

May be look this?

Script:

LOAD Date,If(Date >= '01-05-2017' and Date <= '01-08-2017', Dual('+3 Months',1),

If(Date >= '02-08-2017' and Date <= '02-02-2018', Dual('+6 Months',2),Dual('+12 Months',3))) as Filter;

LOAD Date(MinDate+IterNo()-1) as Date

While MinDate+IterNo()-1 < MaxDate;

LOAD MonthStart(Today()) as MinDate,

MakeDate(2022) as MaxDate

AutoGenerate 1;

Note: Please make sure to create Dynamic Variables for dates and then call them up

Re: Month as Bucket

MindaugasBacius — Thu, 11 May 2017 09:01:56 GMT

What about this:

If(Match([your field], 'May 2017', 'Jun 2017', 'Jul 2017', '+3',

If(Match([your field], 'May 2017', 'Aug 2017', ...., '+6', '+12') as Filter

Re: Month as Bucket

Anonymous — Thu, 11 May 2017 09:34:38 GMT

Hi All,

Here what is the issue?

if(period<=monthname(AddMonths(today(),2)),'3months', // Giving May 2017 -to Jul 2017

(IF(period<=monthname(AddMonths(today(),5)) and cal_period>=monthname(AddMonths(today(),0)),'6MONTHS',//Here I am looking May 2017 to Oct 2017

IF(period<=monthname(AddMonths(today(),18))AND cal_period>monthname(AddMonths(today(),8)),'12MONTHS',// Here I am looking May 2017 to Apr 2018

'N')))) as Bucket

Re: Month as Bucket

beck_bakytbek — Thu, 11 May 2017 13:04:54 GMT

Hi ij qlik,

look at this issue: Class Function

Beck