Logic to get daily records from cumulative data

[Anonymous]

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

[ThornOfCrowns]

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.

[Anonymous]

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

[MK_QSL]

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;