topic Re: Cumulative quantity for each date/month between a date range in QlikView

Cumulative quantity for each date/month between a date range

Anonymous — Thu, 08 Jun 2017 12:53:06 GMT

Hi guys,

I'm trying to create a chart in Qlikview that gives the accumulated quantity for each date between a date range. Let me explain.

I've an excel data which I've loaded into Qlikview and it looks like this :

How can I create a bar chart from this data to look like this :

What if I want the accumulated quantity for each month between a date range ?

Any help would be much appreciated.

Thanks,

Ben

Anil_Babu_Samineni — Thu, 08 Jun 2017 15:31:48 GMT

Here you go

LOAD Quantity, Date(Date,'DD-MMM') as Date;

LOAD *, Date([Start Date] + IterNo() -1) as Date

While Date([Start Date] + IterNo() -1) <= [End Date];

LOAD * Inline [

Product, Quantity, Start Date, End Date

XYZ,10,02/03/2017, 02/15/2017

ABC,20, 02/13/2017, 03/03/2017

];

PS - Then, Create straight table with Date as Dimension and Sum(Quantity) as Expression

Anonymous — Thu, 08 Jun 2017 17:25:22 GMT

That worked Anil. Thanks