Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum stdev

I have the following formula. It takes the stdev of fund return for the last three years. Now I need to sum the result of the formula. I tried sum  and aggr(sum)) none of which seem to work. It either returns 0 or null.

stdev(  {<dte_monthname={'>$(=date((max(dte_monthname))-365*3,'YYYY-MM-DD')) <=$(=date(max(dte_monthname),'YYYY-MM-DD'))'}>} aggr(

            sum( weighted_net_profit) /sum(market_system_weight_current_normalized) , dte_monthname ))

0 Replies