Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
That worked Anil. Thanks