topic Re: Pivot Table Question in QlikView

Pivot Table Question

Wed, 30 Sep 2015 09:59:08 GMT

Hi,

I am new to Qlikview and I am stuck at a point. I am working on Pivot table where I need to display Total sales and sales percentage.The problem starts here, Sales and sales percentage related to a division for a year should be displayed in the same cell of pivot table.

I am attaching the qvw file and the expected output should be like displayed in jpeg file.

Thanks guys for your help

Re: Pivot Table Question

settu_periasamy — Fri, 02 Oct 2015 03:19:47 GMT

Hi,

Try this if you don't get the solution..

remove the % expression..

The Sales Expression should be like

=Num(Sum(Sales),'#,##0')&chr(10)&num(Sum(Sales)/Sum(TOTAL (Sales)),'##,#0%')

Re: Pivot Table Question

petter — Fri, 02 Oct 2015 05:15:46 GMT

For me it looks like it works with your existing expressions - only move the dimensions a bit in the pivot: