How to show non associated data in qliksense pivot table.

[dandaanilreddy]

Hello Qlik Experts,

Please can someone let me know how to achieve the below output in qliksense pivot table.

Country	state	product	sales
USA	CA	APPLE	10
USA	NJ	APPLE	20
USA	MO	APPLE	30
USA	SC	SAMSUNG	40
USA	IL	SAMSUNG	50
USA	KY	SAMSUNG	60

Product Selected: Apple

Expected output;

Country	state	sum(sales)
USA	CA	10
USA	NJ	20
USA	MO	30
USA	SC	NULL
USA	IL	NULL
USA	KY	NULL

Thanks,

Anil Danda

[sunny_talwar]

Isn't this the regular behavior when you have checked 'Include Zero Values' under Data Handling?

[dandaanilreddy]

I have checked the include zero values option but i still didn't get the expected output.

[sunny_talwar · Accepted solution]

Try this expression

Sum(sales) + Sum({1} 0)

[ravi200351023]

Try

=IF((sum(sales)-sum({1}0))=0,'NULL',sum(sales)-sum({1}0))