Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

A custom column in pivot Table

I want to add a calculated column in the pivot table(% of progressive status) which would take an expression and calculate it on the basis of data in that row.

currently I have :

row : Insp.Lot Origin

Column : MonthYear

 

How can this 3rd column be added to the pivot table

Capture 2.PNG

Labels (2)
2 Replies

Please explain the calculation you would like to perform.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner
Partner

in the pivot table I am showing lets say pending lots. In the calculated column I want to show sum of all pending lots from all the months divided by total lots for all the months for the given Insp.Lot origin