Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
settu_periasamy
Master III
Master III

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

View solution in original post

2 Replies
settu_periasamy
Master III
Master III

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

petter
Partner - Champion III
Partner - Champion III

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