topic Standard Deviation in QlikView

Standard Deviation

Mon, 24 Nov 2014 05:01:00 GMT

hi all,

i have two fields, one being date and the other being tweet text.

I need to cal. standard deviation for number of tweets(count) over date.

Thanks

sujeetsingh — Mon, 24 Nov 2014 05:04:19 GMT

Here it is

Use fuction stdev (data)

jagan — Mon, 24 Nov 2014 05:22:18 GMT

Hi,

Try like this

Tweets:

LOAD

1 AS TweetCount

FROM TweetData;

TweetsByDay:

LOAD

Date,

Count(TweetCount) AS TweetsByDate

RESIDENT Tweets;

Now in chart try like this

Chart :

Dimension: Date

Expression: Stddev(TweetsByDate)

Hope this helps you.

Regards,

Jagan.