Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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)