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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek_k
Contributor III
Contributor III

Set analysis in pivot table

country 1 2 3
A 100 20 20
B 0 0 0
C      

 

I have pivot table and want to calculate  for each column something like this:
Column no 1 = sum(1+2+3) 1>= <=3
Column no 2 = sum(2+3+4) 2>= <=4
Column no 30 = sum(30+31+32) 

 

Labels (1)
1 Reply
Mario_De_Felipe
Luminary
Luminary

Hi @jacek_k ,

you could try something like this:

rangesum (after(sum(x),1,3)) 

Best regards,