topic set analysis help in QlikView https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/242098#M92473 <HTML><HEAD></HEAD><BODY><P>I have the expression as</P><P>=count({$&lt;Delay_Month_Convert={"&gt;=$(=Timestamp(MonthStart(AddMonths(Today(), -6)), 'DD/MM/YYYY h:mm:ss[.fff] TT'))&lt;$(=Timestamp(MonthStart(Today()), 'DD/MM/YYYY h:mm:ss[.fff] TT'))"}&gt;}distinct External_HU)/ HU_Count</P><P></P><P>what I am trying to get is a %age of delayed units/ total units loaded</P><P></P><P>So my second part of my expression should have a set analysis as (Delay_month_convert = Load_month) then use Hu_count for division</P><P></P><P></P></BODY></HTML> Wed, 09 Mar 2011 14:12:42 GMT 2011-03-09T14:12:42Z set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/242098#M92473 <HTML><HEAD></HEAD><BODY><P>I have the expression as</P><P>=count({$&lt;Delay_Month_Convert={"&gt;=$(=Timestamp(MonthStart(AddMonths(Today(), -6)), 'DD/MM/YYYY h:mm:ss[.fff] TT'))&lt;$(=Timestamp(MonthStart(Today()), 'DD/MM/YYYY h:mm:ss[.fff] TT'))"}&gt;}distinct External_HU)/ HU_Count</P><P></P><P>what I am trying to get is a %age of delayed units/ total units loaded</P><P></P><P>So my second part of my expression should have a set analysis as (Delay_month_convert = Load_month) then use Hu_count for division</P><P></P><P></P></BODY></HTML> Wed, 09 Mar 2011 14:12:42 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/242098#M92473 2011-03-09T14:12:42Z