topic Re: How to show non associated data in qliksense pivot table. in App Development

How to show non associated data in qliksense pivot table.

dandaanilreddy — Wed, 10 Oct 2018 15:19:25 GMT

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;

Thanks,

Anil Danda

sunny_talwar — Wed, 10 Oct 2018 15:27:49 GMT

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

dandaanilreddy — Wed, 10 Oct 2018 15:30:28 GMT

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

sunny_talwar — Wed, 10 Oct 2018 15:42:12 GMT

Try this expression

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

ravi200351023 — Wed, 10 Oct 2018 17:13:00 GMT

Try

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