topic diverse null values using nullasvalue for diverse columns in QlikView

diverse null values using nullasvalue for diverse columns

ali_hijazi — Thu, 24 Jul 2014 06:58:56 GMT

Hello

I know that we can make null values selectable by using the NULLASVALUE

NULLASVALUE Field1;

SET NULLVALUE =''

what if I want to give "-" for null values for another field say Field2 what would be the syntax?

aveeeeeee7en — Thu, 24 Jul 2014 07:02:46 GMT

Do this in your Script where Field2 is lying in your table and create a new field.

if(Len(Trim(Fied2))>0,Field2,'-') AS NewField2

Regards

Aviral Nag