topic standard deviation in QlikView https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800252#M1049512 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have two fields, 1st is date and 2nd is tweet id and i m counting tweet w.r.t. date.</P><P>i have average but cant find the standard deviation.</P><P>I tried using stdev, buti suppose i m doing something wrong.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Nov 2014 13:36:44 GMT 2014-11-10T13:36:44Z standard deviation https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800252#M1049512 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have two fields, 1st is date and 2nd is tweet id and i m counting tweet w.r.t. date.</P><P>i have average but cant find the standard deviation.</P><P>I tried using stdev, buti suppose i m doing something wrong.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Nov 2014 13:36:44 GMT https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800252#M1049512 2014-11-10T13:36:44Z Re: standard deviation https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800253#M1049513 <HTML><HEAD></HEAD><BODY><P>pls put expression here what u tried </P></BODY></HTML> Mon, 10 Nov 2014 13:40:47 GMT https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800253#M1049513 2014-11-10T13:40:47Z Re: standard deviation https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800254#M1049514 <HTML><HEAD></HEAD><BODY><P>stdev(count(tweet_id))</P><P></P><P>and also tried this</P><P></P><P>stdev(aggr(count(tweet_id)))</P></BODY></HTML> Mon, 10 Nov 2014 13:42:54 GMT https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800254#M1049514 2014-11-10T13:42:54Z Re: standard deviation https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800255#M1049515 <HTML><HEAD></HEAD><BODY><P>try like this</P><P>stdev(aggr(count(tweet_id),date))</P></BODY></HTML> Mon, 10 Nov 2014 13:46:31 GMT https://community.qlik.com/t5/QlikView/standard-deviation/m-p/800255#M1049515 2014-11-10T13:46:31Z