Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
urbanfaces
Contributor III
Contributor III

Calculating the Standard Deviation for based on Two Dimensions

I am new to Qlik, and any help will be greatly appreciated.

I am trying to calculate the standard Deviation. I want the group dimension to be FUNCTION. But it is calculating the entire population.

If I remove Name, the data returns a blank result.

Here is the formula I am using

=StDev(Total Aggr(Count(ID), FUNCTION, NAME). Thanks in advance

urbanfaces_0-1708450539275.png

 

Labels (1)
4 Replies
Anil_Babu_Samineni

@urbanfaces Can't this be simply, Stdev(ID)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
urbanfaces
Contributor III
Contributor III
Author

Thank you for replying. This issue is that I want to group by function based on the employee ID count. StDev(Id) factors the entire population.

urbanfaces
Contributor III
Contributor III
Author

That will give me their respective StDev. I want the StDev for the function as a group.

Anil_Babu_Samineni

@urbanfaces Like this  Stdev(Aggr(Sum(ID), Function))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful