Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
cbaqir
Valued Contributor

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)

Tags (2)
1 Reply
vishsaggi
Esteemed Contributor III

Re: IsNum and Only()

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)