Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

How to find out Standard Deviation

HI Experts

Here , i am having one pivot table with the following

Dim : Region,District,Client (Drill Down Group)

Exp : Label name : Order Hours Peer Average

         sum({<OrderType={'Others'},StandardFlag={1}, GroupName=, ClassName=, CategoryName=,   

                                                                                                                            ModelName=>}StandardHoursPer*OrderCount)

+

sum({<OrderType={'Others'},StandardFlag={0}, GroupName=, ClassName=, CategoryName=, ModelName=>}ActualHours)

How to find out Standard Deviation for "Order Hours Peer Average" expression?

Thanks

1 Reply
tresesco
MVP
MVP

Have you tried stdev() ?