I have question like below,
from above table I need to find the average value like below table,
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.
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')
Round((Sum(Value)-above(TOTAL sum( Value ) ))/above(TOTAL sum( Value ) ),0.001)
Yep, agree with Sunny that's basically a change percentage vs previous day that you are asking for; not an average
if you want to do that in a chart it would be something like below
(Sum(Value) - above(Sum(Value)))/ above(Sum(Value))
If you don't mine, Can you please brief one value how you are getting. Let's think our use case is for 0.5. Tell us how you are getting by paper work condition
the Average that gave is Dummy just for an example
what i actually want is
the Exact Output that i Want:
According to Formula.
(Today-Previous day)/Previous day
Previous day=1/1/2017 value: 4
Previous day=1/2/2017 value: 7
Previous day=1/3/2017 value:4
Please help me out of this.