Qlik Community

Ask a Question

Qlik Sense App Development

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

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

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

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