How to calculate median and Standard deviation for Month aggregation if i have data for day granularity

[Anonymous]

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.

[sunny_talwar]

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))

[JaMajka1]

Could you give us an example?

BR,

Maria