topic How to display nil values using set analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-display-nil-values-using-set-analysis/m-p/249172#M94731 <HTML><HEAD></HEAD><BODY><P>Dear Friends,</P><P></P><P>I have a expression like highest number of invoices based on Reason, this expression works fine but what I need is when there is no data it should display No value or Nil, is it possible using straight table.</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P></P><P><A></A></P><P></P><P><SPAN style="font-size: 10pt;">=if(aggr({1}rank(Count([Invoice])),[Reason]) = 1,Count([Reason])) </SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;">Chriss</SPAN></P></BODY></HTML> Fri, 14 Oct 2011 09:00:16 GMT 2011-10-14T09:00:16Z How to display nil values using set analysis https://community.qlik.com/t5/QlikView/How-to-display-nil-values-using-set-analysis/m-p/249172#M94731 <HTML><HEAD></HEAD><BODY><P>Dear Friends,</P><P></P><P>I have a expression like highest number of invoices based on Reason, this expression works fine but what I need is when there is no data it should display No value or Nil, is it possible using straight table.</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P></P><P><A></A></P><P></P><P><SPAN style="font-size: 10pt;">=if(aggr({1}rank(Count([Invoice])),[Reason]) = 1,Count([Reason])) </SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;">Chriss</SPAN></P></BODY></HTML> Fri, 14 Oct 2011 09:00:16 GMT https://community.qlik.com/t5/QlikView/How-to-display-nil-values-using-set-analysis/m-p/249172#M94731 2011-10-14T09:00:16Z How to display nil values using set analysis https://community.qlik.com/t5/QlikView/How-to-display-nil-values-using-set-analysis/m-p/249173#M94732 <HTML><HEAD></HEAD><BODY><P>may be one of this one</P><P></P><P>if(aggr({1}rank(Count([Invoice])),[Reason]) = 1,Count([Reason]),'NO Value')</P><P>or</P><P></P><P>if(aggr({1}rank(Count([Invoice])),[Reason]) = 1,Count([Reason]),'Null')</P></BODY></HTML> Fri, 14 Oct 2011 09:12:17 GMT https://community.qlik.com/t5/QlikView/How-to-display-nil-values-using-set-analysis/m-p/249173#M94732 SunilChauhan 2011-10-14T09:12:17Z