Qlik Community

Ask a Question

App Development

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

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 

In Pivot table, values are missing while dividing each cell value with totals


My requirement here is to divide each cell value with the totals. That means in Backlog target, it should give 707/871 which is 0.81. Similarly I need the values in rest of cell like 5/871, 12/871, 7/871, 23/871 goes on.. However I am getting values in certain cells only not all. Not sure what I am missing here. The formula I am using is (aggr(Count(UNIQUE_ID),MONTH_DUE,DELIVERED_BY)/aggr(Count(UNIQUE_ID),MONTH_DUE))

Can someone help me to figure out the issue?

Labels (1)
0 Replies