How to find average value based on Dates?

[#1]

Hi,

I have question like below,

Name	Date	Value
A	1/1/2017PM	4
B	1/2/2017PM	7
C	1/3/2017PM	4
D	1/4/2017PM	3

from above table I need to find the average value like below table,

Name	Date	Value	Avg.Value
A	1/1/2017PM	4	0.5
B	1/2/2017PM	7	-0.14
C	1/3/2017PM	4	0.545
D	1/4/2017PM	3	-0.33

The above average value is Dummy just for an example

I need output like above table

By using this below formula to find Avg value's

The formula  for  Avg Value:

=(Today- Previous day)/Previous day*100

In qlik it will be possible to find the Avg.Value dynamically. I am looking for expression wise to get the Avg.Value dynamically.

vengadeshpalani‌ yoganantha321‌

Regards,

Muthukumar

[vinieme12]

Have you tried the expression I posted above?

[Anil_Babu_Samineni · Accepted solution]

Now Clear,

Try this? and suppress when value is null from Presentation tab of Metric

Num((Sum(Value)-above(TOTAL sum( Value ) ))/above(TOTAL sum( Value ) ),'#,##0.00')

Update -

Round((Sum(Value)-above(TOTAL sum( Value ) ))/above(TOTAL sum( Value ) ),0.001)

[#4]

Thanks For your Expression Anil

may i know  the Difference between

Num((Sum(Value)-above(TOTAL sum( Value ) ))/above(TOTAL sum( Value ) ),'#,##0.00')

and

Update -

Round((Sum(Value)-above(TOTAL sum( Value ) ))/above(TOTAL sum( Value ) ),0.001)

[Anil_Babu_Samineni]

First expression works with Rounded Numbers. but second one gives exact value like you mentioned -0.42

That is how i initiate Round with 0.001

PS - I would request you to close this thread if you found solution as you expecting and please Mark helpful if you found at least any helpful over the thread.

[#6]

Thank you So Much, Anil. It is Working fine but for Both the Expression I am Getting same out put. it is not Showing the Exact Values it is Rounding of the values and it is Showing

[Anil_Babu_Samineni]

In that second expression, Just use with out Num() as i mentioned last reply