Join in Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am trying to use outer join but output was not accurate when I try to show it in Pivot Table,it was working fine when output shown in Table Box.Anyone please help me in this issue.

My sample data looks like:

Product:

Load * Inline [

ProductID,Product

1,aaa

2,bbb

3,ccc ];

Outer Join(Product)

Sales:

LOAD * Inline [

ProductID,Product,SalesAmount

1,aaa,10

2,bbb,20

4,ddd,40

5,eee,50 ];

Sample Output(Pivot Table):

Product ID	Product	SalesAmount	Sum(SalesAmount)
1	aaa	10	10
2	bbb	20	20
4	ddd	40	40
5	eee	50	50

Output Table Box:

Product ID	Product	SalesAmount
1	aaa	10
2	bbb	20
3	ccc	-
4	ddd	40
5	eee	50

Re: Join in Pivot Table

sunny_talwar — Wed, 25 Jan 2017 14:07:27 GMT

I think you need to uncheck 'Suppress Zero Values' on the presentation tab of chart properties

Re: Join in Pivot Table

sunny_talwar — Wed, 25 Jan 2017 14:09:07 GMT

Re: Join in Pivot Table

Anonymous — Wed, 25 Jan 2017 14:12:06 GMT

Thank you Sunny

topic Re: Join in Pivot Table in QlikView

Join in Pivot Table

Re: Join in Pivot Table

Re: Join in Pivot Table

Re: Join in Pivot Table