Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing an issue while calculating the median and Standard deviation in Qlikview for Monthly aggregation.Because i have data for day granularity.
When i validate the data with Excel and qlikview the Median and standard devition functions are not working properly.
Please help on the above issue.
May be you need to sum the daily values and then calculate the median and standard deviation?
Dimension
Month
Expression
Median(Aggr(Sum(Value), Date))
Stdev(Aggr(Sum(Value), Date))
Could you give us an example?
BR,
Maria