Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Overall Average and StDev from table

Hi All,

I've got the below table which is the performance by person by hour in a day.  I'm trying to get the average and stdev by person and hour.

Tbl.png

What I want to get via set analysis is the average and stdev per person per hour for the whole table.

In the above table the total is 1408.4 and the average is 28.74.  The tricky thing in this is the hour is part of a drill down group so goes Month / Day / Hour and the Person is based on another drill down so goes Location / Manager / Legal Name.

The ultimate output i'm looking to produce is the below chart showing upper and lower control limits based on the above data table.

chrt.png

Many thanks

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

See this blog post: QlikView Control (SPC) Chart


talk is cheap, supply exceeds demand