Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
kavirao
Contributor II
Contributor II

Pivot Table

Hi

1) I am working on pivot table where i have multiple calculation involved like stdev and z-score.

Below is the sample table where I need to calculate stdev for Q1 , Q2, Q3, Q4  so it has to pass values of company into stdev function stdev(8,2,0,0,0) for Q1 etc....  ( the values in pivot table  used formula with few conditions)

That result I need to store in array where i can use  for z-score 

Company Q1 Q2 Q3 Q4
A 8 4 0 7
B 2 0 5 2
C 0 3 0 0
D 0 0 2 0
E 0 2 0 4
F 1 0 3 2
Total 11 9 10 15
Stdev        
Labels (1)
1 Reply
vinieme12
Champion III
Champion III

Like below

stdev(TOTAL <Quarter> aggr( sum(Xyz) , Company,Quarter))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.