if function

[ridleyyeh]

i connected my sql into qliksense  and finished loading data but found out there are so many NULL datas in some columns.

There are so many columns which contains null values but some columns CANNOT BE NULL ,such as " Name","IDCard" and "Status"must be  4 , AND  those data that i just describe is something  need to be calculated

So i wanna create a column called "ValidData" that divide them into two types of data, one is the data that i can actually  use and calculate and another one is Error data that i cant use but i wanna keep it .

So I know i have to make Multiple IF Functions , i wanna make "data that i can use and calculate"into"1" in ValidData

and the rest of part is "0"  .

How can i make those functions to define and divide in "ValidData" ? thanks !

[Anil_Babu_Samineni]

Can you please share with us, what you have tried so far?