Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Pivot Table sum dimensions

Hi, I have my pivot(dim1 Prod, dim2 Esp), but want repeat sum Mat0  value  in col Tot; % =Mat0/Tot

Mat0=Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)

 

pivot.png

3 Replies
Highlighted
Master II
Master II

Re: Pivot Table sum dimensions

Hi Ronald,

Can you please explain your requirement a bit more ? A sample data and expected output sample will be helpful to understand. 

Best Regards,
KC
Highlighted
Contributor II
Contributor II

Re: Pivot Table sum dimensions

Hi, good mornig.

I need %P1 = 11/91

91 is sum horizontal for Esp1

11 is Mat0 value 

Mat0=Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)

 

Highlighted
Contributor II
Contributor II

Re: Pivot Table sum dimensions