topic Re: filling empty cells in QlikView

filling empty cells

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

in a table I use the formular

=round(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber),'0,1')

some cells have no value, are empty.

But I need a 0 instead an empty cell.

The Icon in the Table-Menue to showt nullvaliues doesn't work and the skript is very complicated. So I search for a solution in this specific table.

Thanks!

Re: filling empty cells

sunny_talwar — Thu, 06 Oct 2016 17:57:21 GMT

May be use these settings on the presentation tab of the chart properties

Re: filling empty cells

Anonymous — Thu, 06 Oct 2016 18:35:00 GMT

sometimes if above option does not work then implement this if statement. If (len(feild)=0,0,yourexpression)

Re: filling empty cells

Thu, 06 Oct 2016 18:56:05 GMT

like this?

if(len(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber) = 0,0, round(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber),'0,1')

or what do you mean with len(field)?

Re: filling empty cells

Anonymous — Thu, 06 Oct 2016 19:24:57 GMT

you can either use the expression you posted or use len(VD)=0. let me know if that helps.

Re: filling empty cells

Thu, 06 Oct 2016 19:30:32 GMT

tomorrow in the office I try this and then tell you if it works.