Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,.
I need some inputs from you where i need to create a command that makes cumulative data into daily totals ?
Is there such a command?
attached is the sample Qlikview and Excel file to look at it
Please respond me
This is the same question as the one you posted in command for Cummilative data into Daily totals
Please just use that one as it will fragment the discussion and make a possible answer more difficult. Thanks.
yes i was not proper in the requirement thought all those who wants to help may be puzzled so i started a new one.
If you can help me please help me on this scenario
Input:
LOAD Reg,
[Date and Time],
Date,
Reg & Date as Key,
Cum
FROM
[Cumulative Example.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join (Input)
Load Key, FirstSortedValue(Cum, -[Date and Time]) - FirstSortedValue(Cum, [Date and Time]) as Daily Resident Input
Group By Key;
Drop Field Key;