Discussion Board for collaboration related to QlikView App Development.
I have a source dataset like as,
I need to calculate the average % based upon the Date value in the straight tablethe average %That means my calculation will be
Example: Let me consider Category "A" value, for that i need the calculation like
(Value_v1 of 01/01/2017PM) - (Value_v1 of 01/01/2017AM) - / (Value_v1 of 01/01/2017AM)
(Value_v1 of 01/01/2017AM) - (Value_v1 of 01/01/2017PM) - / (Value_v1 of 01/01/2017PM)