topic Re: How to avoid null in pivot table while using input boxes in QlikView

How to avoid null in pivot table while using input boxes

prasadreddy — Wed, 21 Aug 2013 07:40:26 GMT

Hi All,

Can any one help me on avoiding the empty cells in the pivot chart,

please take look on following attached screenshot,

i have given iput values to filter the data based on "difference", it working properly, but i want to appear only list based on the

input boxes, here the remaining is showing withnull symbol ' - ', so i dont want to show that,

thanks in advance

Re: How to avoid null in pivot table while using input boxes

er_mohit — Wed, 21 Aug 2013 07:44:49 GMT

in presentation tab at bottom side you 'll find null symbol with - and missing symbol with -

replace null symbol with 0

hope it helps

Re: How to avoid null in pivot table while using input boxes

abeyphilip — Wed, 21 Aug 2013 08:02:00 GMT

Hi,

As I understand you don't want the rows with '-' in your Difference column.

I am not sure if the pivot properties will let you do that since you have values for other expression columns in that row.

Can you try creating a list box that will have "yes" or "no" based on the value for Difference.

The list box expression will be something like:

if((aggr({<condition for 201211>} 201211),Account)

aggr({<condition for 201304>} 201304),Account))

>0, 'Yes', 'No')

So selecting "yes" will ensure you have only rows with value in Difference column.

Re: How to avoid null in pivot table while using input boxes

Wed, 21 Aug 2013 08:22:38 GMT

Try adding an extra condition in all of your expressions to say that if the result of that expression is "outside" (or whatever the requirement is) of your min. and max. difference, then show null() or zero. And how the setting to suppress zero enabled in the properties of the table.