topic Re: stdev help! in QlikView

stdev help!

qlikviewforum — Wed, 14 Jan 2015 07:07:26 GMT

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)

tresB — Wed, 14 Jan 2015 07:11:12 GMT

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

qlikviewforum — Wed, 14 Jan 2015 07:14:14 GMT

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

tresB — Wed, 14 Jan 2015 07:22:10 GMT

Try:

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