topic Re: Pivot table - Show null values as different calculation in QlikView

Pivot table - Show null values as different calculation

knraju123 — Wed, 23 Jun 2021 14:48:37 GMT

Hi Community,

I'm facing issue with Pivot table - Actually Pivot table is working fine for me, but facing issue with one scenario.

below screen showing correct, May 2021 value 4,453 and June to Dec showing Null i.e correct - but I have to show different calculation value or any number..

same as ABC2 client values are showing in June, it should be greater June month... similar as below clients

([Amount (USD)]*[Gross BPS])/12*0.5 as Revenue, - 4453
([Amount (USD)]*[Gross BPS])/12 as WithoutBonus - 8906 (can you please help me on this value, not able to get this value)

PFA,..

Re: Pivot table - Show null values as different calculation

knraju123 — Wed, 14 Jul 2021 15:58:55 GMT

Hi Experts,

Still I'm facing on this issue, can you please help me!

Re: Pivot table - Show null values as different calculation

Lafayette — Thu, 15 Jul 2021 11:30:01 GMT

Click the PivotTable report. On the Options tab, in the PivotTable Options group, click the arrow next to Options, and then click Options. Click the Layout & Format tab, and then do one or more of the following: AdvancedMD Change error display Select the For error values, show check box under Format.