Discussion board where members can get started with QlikView.
Hi all i have a data set as like shown in the image 1:
But I need as split wise based on the month
as shown in image 2:
Attached excel file for reference.
Yoganantha Prakash G P
Go to Solution.
Perhaps something like this:
RangeMax([Start Date],MonthStart([Start Date],IterNo()-1)) as [Start Date],
RangeMin([End Date], MonthEnd([Start Date],IterNo(),-1)) as [End Date],
...source...WHILE MonthStart([Start Date], IterNo()-1) < [End Date] ;
It is not working.
ID 1 Apple not loaded at all.
The start date of ID 1 lies before its end date: