Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Pivot Table Question

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

1 Solution

Accepted Solutions

Re: Pivot Table Question

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%')

Capture.JPG

2 Replies

Re: Pivot Table Question

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%')

Capture.JPG

MVP
MVP

Re: Pivot Table Question

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

2015-10-02 #1.PNG