Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried the expression I posted above?
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)
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)
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.
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
In that second expression, Just use with out Num() as i mentioned last reply