3 Replies Latest reply: Apr 6, 2018 9:06 AM by Sunny Talwar

How to find mean,median and standard deviation in Pivot table in Qlik Sense

Vivek Anand Apr 6, 2018 8:05 AM

I have created a pivot table with a measure, columns, and rows.

Now I want to find mean, median and standard deviation of particular columns fields values.

How can I find this?

Re: How to find mean,median and standard deviation in Pivot table in Qlik Sense

Sunny Talwar Apr 6, 2018 8:21 AM (in response to Vivek Anand)

Use Avg() for Mean, Median() for Median, and Stdev() for standard deviation
Like Show 1 Like (1)

Actions
- Re: How to find mean,median and standard deviation in Pivot table in Qlik Sense
  
  Vivek Anand Apr 6, 2018 9:06 AM (in response to Sunny Talwar )
  
  thanks,
  Mean and Range i have already tried and just now I tried for Median and Standard deviation
  It's working fine
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: How to find mean,median and standard deviation in Pivot table in Qlik Sense
    
    Sunny Talwar Apr 6, 2018 9:06 AM (in response to Vivek Anand)
    
    Awesome
    
    Like Show 1 Like (1)
    
    Actions