Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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%')
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%')
For me it looks like it works with your existing expressions - only move the dimensions a bit in the pivot: