topic pivot table with null in QlikView

pivot table with null

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

Hi All,

I have horizontal pivot table and i have issues to find/calculate nulls values in the expression using if() condition.

I am using below expressions to calculate sales, if no sales available i want to throw blank. But in few cases it returns blank, but in other cells it returns '-'

if(not isnull(sum(sales) or len(sum(sales)) >0,

sum(sales),' ')

Please help

Re: pivot table with null

sunny_talwar — Fri, 06 Oct 2017 12:31:17 GMT

Would you be able to share a sample to show the issue?

Re: pivot table with null

el_aprendiz111 — Fri, 06 Oct 2017 12:31:44 GMT

Hi,

1 Option...

Re: pivot table with null

surajdhall — Fri, 06 Oct 2017 12:48:08 GMT

I will prepare the same in few minutes. Thanks

Re: pivot table with null

surajdhall — Fri, 06 Oct 2017 13:41:29 GMT

Hi Sunny

you can see down arrows, where i want blanks, as there is no data in the next month, so i want bank instead of arrow.

Please help!

Re: pivot table with null

sunny_talwar — Fri, 06 Oct 2017 13:54:44 GMT

So wherever you have NA, you would not want to see any arrow?

Re: pivot table with null

surajdhall — Fri, 06 Oct 2017 14:00:55 GMT

Yes. But not in below case. In below case. For April there is up arrow as there is data in May, But no arrows should be shown in Mar, below is correct. But in previous screenshots that i posted there are down arrows, which are incorrect.

Re: pivot table with null

sunny_talwar — Fri, 06 Oct 2017 14:04:05 GMT

I understand the up arrow in May-2017.... but why is there an up-arrow in Apr-2017? Mar-2017 and Apr-2017 have both N/A... why up arrow for Apr-2017 then?