Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
joshrussin
Contributor III

Pivot Table with sum and percentage in the same cell

I am having some issues with getting this table to tell me the sum of errors and the percentage of errors on any given day in the same cell. Ex. "5 errors / 15%"

Attached is my example. For this was just for testing area1 and I was trying to just add the totals together for conceptual certainty. So for area1 on 9/3 should say "5 Errors / 16%", area1 on 9/4 should say "7 Errors / 17%", and area1 on 9/5 should say "4 Errors / 18%"

I'm sure there is an easier way to go about this, I believe I'm just overthinking this.