Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

IsNum and Only()

How do I use isnull in an only() statement?

=only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Operating'}, isnull(AU_NUM), isnull(MOR_TOWER)>}NOTE)

1 Reply
vishsaggi
Champion III
Champion III

May be this?

= only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Operating'}, AU_NUM = {"=Len(Trim(AU_NUM))= 0"}, MOR_TOWER = {"= Len(Trim(MOR_TOWER)) = 0"} >} NOTE)