Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Spread total over different time periods

Hi Everyone,

I need some help with a pivot chart, let me start by explaing what i want to do.

I have a file with the following data, items, item category, value date and a total amount. What i want to do is create a sort of maturity profile. Where each item due in a certain period will be clubbed in a bucket as shown in the table below.


Item CategoryTotal Amount1 week> 1 week1 month1 - 3 months3 - 6 months> 6 months



So basically, item category will show the total amount (which is the amounts of all the items in that particular category) and which will be divided as in the table by the value date.

I have tried using this method,

Sum(If(AddMonths(Value_Date,3), Amt_F)) but this gives me the entire amount instead of the relevant part.

Can someone suggest a solution?

Many Thanks.

0 Replies