topic Re: Bucket Help in QlikView

Bucket Help

sona_sa — Fri, 27 Feb 2015 06:59:11 GMT

Hi,

I have a field [Fiscal year/period_FISCPER], i.e nothing, It is month in the format of yyyymmm. Now I want bucket in the group of 3 months, Like 0-90, 91-180,......

Can I do the same in the same format. Also I would like to tell you 016 is December month for every year. Like 2009016 - Dec-2009.

Please help as soon as possible. Find the attached xls for ref.

Thanks.

Re: Bucket Help

MK_QSL — Fri, 27 Feb 2015 07:33:56 GMT

bucket based on what? what s the measure field ?

Re: Bucket Help

sona_sa — Fri, 27 Feb 2015 07:48:44 GMT

0 - 3 Months

4 - 7 Months

8 - 10 Months

11 - 13 Months

14 - 16 Months

17 - 23 Months

24 - 30 Months

31 - 36 Months

36 - 42 Months

> 43 Months

Will be bucket as a dimension. Measure will be Sum(Balance).

Regards,

Amit Kumar

Re: Bucket Help

MK_QSL — Fri, 27 Feb 2015 08:28:30 GMT

Can you also provide the result in excel which you are looking for?

Re: Bucket Help

its_anandrjs — Fri, 27 Feb 2015 08:35:11 GMT

In a month field what is mean for the 2014009 what is date format or you can use Class Function Here in the calculated dimension. If last two digit in the field is Month then try

Dim:- Replace( Class(Right(Month,2),'3') ,'<= x <' , ' ' ) &'Months'

Expre:- Sum(Balance)

Regards

Anand

Re: Bucket Help

kamalqlik — Fri, 27 Feb 2015 10:15:46 GMT

Please share correct Excel.

Regards

Kamal