topic Re: Stdev, ignore dates with zero values in QlikView

Stdev, ignore dates with zero values

Thu, 25 Jun 2015 13:47:15 GMT

Hi,

I need to calculate the StDev of AMOUNT however when trying stdev(AMOUNT) I receive an incorrect value since it is also accounting for dates with zero values. I want it to calculate for dates with data only in my date range selection.

Any ideas?

Regards,

Olle

Re: Stdev, ignore dates with zero values

Fri, 26 Jun 2015 08:50:15 GMT

anyone?

Re: Stdev, ignore dates with zero values

swuehl — Fri, 26 Jun 2015 08:56:06 GMT

Maybe like

stdev({<AMOUNT= {"*"} >} AMOUNT)

stdev({<AMOUNT= {">0"} >} AMOUNT)