Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Vinesh
New Contributor

How to create bucket with overlapping values on chart?

Hi All,

I am creating a dimension values bucket with overlapping values on chart and it not giving correct result.

Data is available in below form in QlikSense.

MonthAmount
Jan10
Feb20
Mar30
Apr40
May50
Jun60

 

Month Bucket dimension has been created with below formula.

=if( Month='Jan', '1st Month',

if( match( Month, 'Jan', 'Feb', 'Mar'), 'Quarter',

if( match( Month, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun'), 'Half Year',

) ) )

However, when I use it with Amount measure in Chart, it is only considering Jan month specific amount in '1st Month' bucket and not in next two buckets.

Basically, output is required in below form

Month BucketAmount
1st Month10
Quarter60
Half Year210

 

It should calculate amount for each bucket considering earlier month(s) as

1st Month = 10

Quarter = 10+20+30 i.e. 60

Half Year = 10+20+30+40+50+60 i.e. 210

May I know what are changes required in calculating Amount measure/expression?

Any help will be highly appreciated.

 

Regards,

Vinesh

1 Reply
mahaveerbiraj
Contributor

Re: How to create bucket with overlapping values on chart?

Hi  Vinesh,

you need to create multiple  columnsfor each 1st month ,Quarter and Half year  or  still you want single column  you need to duplicate the rows like below ,

 

MonthAmountMonth Bucke
Jan101st Month
Jan10Quarter
Feb20Quarter
Mar30Quarter
Jan10Half Year
Feb20Half Year
Mar30Half Year
Apr40Half Year
May50Half Year
Jun60Half Year