Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add New Column (flag)

Hi world! I came from the green side (Qlik) so I´ve found some problemns developing some "script" tasks that for sure you will help me It´s really easy. I want to add a new column (flag colu...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    Try this formula

     

    Column = IF(LEN(Table[COLUMN_D])=0 && Table[TYPE] <> "house",1,0)

     

    OR

     

    Column = IF(Table[COLUMN_D]=BLANK() && Table[TYPE] <> "house",1,0)

     

Omega's avatar
Omega
Impactful Individual
7 years ago

Try 

 

Flag = IF(ISBLANK(Table2[ID]) && Table2[TYPE,] <> "House",1,0)