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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.