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 column Percentage

Hi need the percentage of my Column; the dimensions are Prod, Esp, but the dimension Tot is created; the total for Esp1 is 91, the percentaje is 11/91

 

pivot.png

Labels (2)
5 Replies
Highlighted

Re: Pivot Table column Percentage

What is the expression for Mat0? Assuming it is Sum(Measure), you can try this

Sum(Measure)/Sum(TOTAL <Esp> Measure)

 

Highlighted
Contributor II
Contributor II

Re: Pivot Table column Percentage

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

Re: Pivot Table column Percentage

Try this

Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)/
Sum(TOTAL <Esp> {<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)
Highlighted
Contributor II
Contributor II

Re: Pivot Table column Percentage

Hi, good mornig.

I need %P1 = 11/91

91 is total horizontal for Esp1

11 is Mat0 value

Highlighted
Contributor II
Contributor II

Re: Pivot Table column Percentage