topic Re: STDEV calculates incorrect values in QlikView

STDEV calculates incorrect values

Thu, 10 Dec 2015 13:16:17 GMT

Hi all,

I'm working on report which should represents item consumption in last 52 weeks. I have data loaded from our database in format which you can see in attached excel file on sheet1(this is export from my QV).Where OBITNO is an item number and radek is a week number. Numbers represent consumption of item in each week(QTY). I calculate STDEV for each item with standard STDEV function: stdev(QTY). I have export sample of 500 items to excel and I found out that stdev for approximately 70 items is calculated incorrectly in QV. In attached file you can find comparsion for 18 items(Sheet2). Does anyone have any idea what I'm doing wrong and how to correct it? Many thanks in advance.

Re: STDEV calculates incorrect values

sinanozdemir — Thu, 10 Dec 2015 16:40:30 GMT

Hi,

I got the same results as the Excel STDEV function:

In both straight and pivot tables, I used Stdev() function:

Hope this helps.

Re: STDEV calculates incorrect values

Thu, 10 Dec 2015 16:52:32 GMT

Hi,

Could you please attach your test file here? Maybe it will help me to resolve this issue. Thanks in advance.

Re: STDEV calculates incorrect values

sinanozdemir — Thu, 10 Dec 2015 18:25:30 GMT

There you go.