stdev help!

[qlikviewforum]

How can I use STDEV on top of the below set analysis? Please help!

(SUM({<

Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod)))'}

  >}

    (Value/Limit))

)

/

count(distinct{<

Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod)))'}>} Period)

[tresesco]

Set analysis could be used in any aggregation function. So, you can use it similarly in stdev() as well as in sum().

[qlikviewforum]

May I know what would be the change in above set analysis?

[tresesco]

Try:

Stdev({<Period = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod)))'}>} (Value/Limit) )