Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Columns with null values.

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'

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this,

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

From xyz;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

Ok thanks .

Kushal_Chawda

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

From xyz;