This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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)
View solution in original post
can you show me how you got the first avg and the second one as it is not consistent. normal calculator then I will do it.
I think what you really want is not the average, but the growth number, right? and do you need this in the script or front end object?
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))
Even with the growth number it is still not working.
Where are you looking to get this done? Script or front end?
He wants to do this requirement for expression level.
Thanks for your response Sunny
I need this to be done in Front end Expressions(Straight Table)
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.