Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Standard deviation for table.

Hi,

I need to calculate of standard deviation on column Type for every date. But I am not able to use stdev function. It just gives, empty boxes.

TypeNumber of daysDateCount
CC111-Aug-20121
CC162-Aug-20121
CC113-Aug-20121
CC112-Aug-20121
DD111-Aug-20121
DD111-Aug-20121
DD161-Aug-20121
DD161-Aug-20121
DD312-Aug-20121
DD312-Aug-20121
DD313-Aug-20121
DD313-Aug-20121
EE62-Aug-20121
EE62-Aug-20121
EE62-Aug-20121
EE62-Aug-20121
EE63-Aug-20121
EE113-Aug-20121
EE312-Aug-20121
EE312-Aug-20121

I tried to create table with Type, Number of Days, Date, Sum(Count), stddev(Aggr(Sum(Count),Type,Number of Days).

But stddev function is showing empty values.

Any advice how to make it work?

Thanks in advance for your help.

2 Replies
Not applicable
Author

Hi Andre,

Stddev is a group function ie, needs more than one value for input. In the above expression only one unique value exists for each type and number of days; equivalent of saying stddev(1) and hence no stddev. May be you need to articulate the functional need of stddev for me to help.

Regards,

Kiran.

Not applicable
Author

Hi Kiran, Thanks for response. Let me to take a step back and try to check my requirement again.