topic Re: null value in a table in QlikView

null value in a table

ecabanas — Wed, 13 Feb 2013 14:24:47 GMT

Hi,

I have the following table:

FAMILIA	DES_SUB1	DES_SUB2	ITEMID	ITEMNAME	Stock	Consumption	Days	Stocking days
Total					6	0	19
01.ALIMENTACION	01.DESAYUNOS Y MERIENDAS	CACAO Y CREMAS	8410109001631	VALOR CHOCOLATE TAZA	6	0	19	-

The formula: "Stocking days" is a calculation: (Stock/Consumtion)*365 but in this case I have a stocking days "-". I tryied with this, but it does not work:

If( (Stock/Consumtion)*365 =null();0; (Stock/Consumtion)*365)

I would like to do, If it's "-" then '0'

Thank's

Re: null value in a table

kouroshkarimi — Wed, 13 Feb 2013 14:29:54 GMT

In the bottom left of the presentation tab you can set the replacement characters for null values. (Null Symbol & Missing Symbol). Try using isnull(value)=-1 instead of value=null() in your if statement.

Re: null value in a table

ecabanas — Wed, 13 Feb 2013 14:34:54 GMT

thank's it works!!!!