topic Re: Columns with null values. in QlikView

Columns with null values.

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

Hi,

I wanted to use this logic in QlikView, what functions do I use??

Code:

If (Date) is null

then usp* tax

else 0

Explanation:

When the (Date) column is null then 'usp*taxes' else '0'

kaushiknsolanki — Mon, 23 Oct 2017 08:06:20 GMT

Try this,

Load *,If(isnull(DATE),USP*TAXES,0) as New Field

From xyz;

Regards,

Kaushik Solanki

Anonymous — Mon, 23 Oct 2017 08:07:36 GMT

Ok thanks .

Kushal_Chawda — Mon, 23 Oct 2017 09:24:41 GMT

Load *,If(len(trim(DATE))=0,USP*TAXES,0) as New Field

From xyz;