topic IsNum and Only() in QlikView https://community.qlik.com/t5/QlikView/IsNum-and-Only/m-p/1221461#M390497 <HTML><HEAD></HEAD><BODY><P>How do I use isnull in an only() statement?</P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[NOTE_TYPE]</SPAN><SPAN style="font-size: 8pt;"> = {'TOP'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">EXP_TYPE_CODE</SPAN><SPAN style="font-size: 8pt;">={'Operating'}, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">isnull</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">AU_NUM</SPAN><SPAN style="font-size: 8pt;">), isnull(MOR_TOWER)&gt;}NOTE)<BR /> </SPAN><BR /> </SPAN></P></BODY></HTML> Thu, 02 Mar 2017 22:25:59 GMT cbaqir 2017-03-02T22:25:59Z IsNum and Only() https://community.qlik.com/t5/QlikView/IsNum-and-Only/m-p/1221461#M390497 <HTML><HEAD></HEAD><BODY><P>How do I use isnull in an only() statement?</P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[NOTE_TYPE]</SPAN><SPAN style="font-size: 8pt;"> = {'TOP'},</SPAN><SPAN style="color: #800000; font-size: 8pt;">EXP_TYPE_CODE</SPAN><SPAN style="font-size: 8pt;">={'Operating'}, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">isnull</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">AU_NUM</SPAN><SPAN style="font-size: 8pt;">), isnull(MOR_TOWER)&gt;}NOTE)<BR /> </SPAN><BR /> </SPAN></P></BODY></HTML> Thu, 02 Mar 2017 22:25:59 GMT https://community.qlik.com/t5/QlikView/IsNum-and-Only/m-p/1221461#M390497 cbaqir 2017-03-02T22:25:59Z Re: IsNum and Only() https://community.qlik.com/t5/QlikView/IsNum-and-Only/m-p/1221462#M390498 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>= only({&lt;[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Operating'}, AU_NUM = {"=Len(Trim(AU_NUM))= 0"}, MOR_TOWER = {"= Len(Trim(MOR_TOWER)) = 0"} &gt;} NOTE)</P></BODY></HTML> Thu, 02 Mar 2017 22:28:56 GMT https://community.qlik.com/t5/QlikView/IsNum-and-Only/m-p/1221462#M390498 vishsaggi 2017-03-02T22:28:56Z