topic Re: Suppress Nulls In Expression in QlikView https://community.qlik.com/t5/QlikView/Suppress-Nulls-In-Expression/m-p/459280#M1166142 <HTML><HEAD></HEAD><BODY><P>I think it was solved: <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/265172#265172" title="http://community.qlik.com/message/265172#265172">http://community.qlik.com/message/265172#265172</A></P></BODY></HTML> Mon, 08 Oct 2012 18:07:10 GMT whiteline 2012-10-08T18:07:10Z Suppress Nulls In Expression https://community.qlik.com/t5/QlikView/Suppress-Nulls-In-Expression/m-p/459279#M1166141 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have the following code in my expression of a pivot table:</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'Total Treatment Time' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Admitted', 'Non Admitted','') = 'Admitted', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Median</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total Wait]</SPAN><SPAN style="font-size: 8pt;">)/1440,<BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'Total Treatment Time' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Admitted', 'Non Admitted','') = 'Non Admitted', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Median</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total Wait]</SPAN><SPAN style="font-size: 8pt;">)/1440,<BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Total Treatment Time', 'To Initial Treatment', 'Left Without Being Seen') = 'To Initial Treatment' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ValueList</SPAN><SPAN style="font-size: 8pt;">('Admitted', 'Non Admitted','') = '', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Median</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total Wait]</SPAN></P><P><SPAN style="font-size: 8pt;">)/1440)))<BR /><BR /><BR /></SPAN></P><P> I have searched this forum and it is suggested that set analysis will get rid of any nulls</P><P></P><P>Could you kindly help me write the set analysis for </P><P><SPAN style="color: #0000ff; font-size: 8pt;">Median</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total Wait]</SPAN><SPAN style="font-size: 8pt;">)/1440</SPAN></P><P>?</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Tue, 02 Oct 2012 12:01:19 GMT https://community.qlik.com/t5/QlikView/Suppress-Nulls-In-Expression/m-p/459279#M1166141 helen_pip 2012-10-02T12:01:19Z Re: Suppress Nulls In Expression https://community.qlik.com/t5/QlikView/Suppress-Nulls-In-Expression/m-p/459280#M1166142 <HTML><HEAD></HEAD><BODY><P>I think it was solved: <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/265172#265172" title="http://community.qlik.com/message/265172#265172">http://community.qlik.com/message/265172#265172</A></P></BODY></HTML> Mon, 08 Oct 2012 18:07:10 GMT https://community.qlik.com/t5/QlikView/Suppress-Nulls-In-Expression/m-p/459280#M1166142 whiteline 2012-10-08T18:07:10Z