Discussion Board for collaboration related to QlikView App Development.
I'm hoping this is simple.
I want to group the Instrument with Start and End Dates, and ultimately calculate the total number of weeks attached to each.
I have attached two screenshots below. The 1st is the raw dataset, and the 2nd is what I want to achieve in Qlikview. How do I do it?? Any help would be great.
[number of weeks]
(biff, embedded labels, table is Sheet1$);
LOAD If(Name = Previous(Name), If(Instrument = Previous(Instrument), Peek('Sort'), RangeSum(Peek('Sort'), 1)), 1) as Sort,
Order By Name, [Start Date] desc;
Min([Start Date]) as [Start Date],
Max([End Date]) as [End Date],
Sum([number of weeks]) as [number of weeks]
Group By Name, Instrument, Sort;
DROP Tables Table, TempTable;
View solution in original post
What is the grouping logic you used here? On what criteria you considered Drums which is coming twice?
Excellent. Thank you Sunny