Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Standard Deviation

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

2 Replies
Highlighted
Honored Contributor III

Re: Standard Deviation

Here it is

http://community.qlik.com/thread/46850

\

Use fuction stdev (data)

Highlighted
MVP & Luminary
MVP & Luminary

Re: Standard Deviation

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.