topic Set Analysis - Help in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/369962#M577918 <HTML><HEAD></HEAD><BODY><P>I found a way to do this</P><P>by using this expression:</P><P></P><P>=Num(count(DISTINCT {&lt;DT_END = {"&gt;=$(#Var_Dat)"}, DT_START = {"&lt;=$(#Var_Dat)"}&gt;} ID_ACC),'#,##0')</P></BODY></HTML> Mon, 26 Mar 2012 20:36:42 GMT 2012-03-26T20:36:42Z Set Analysis - Help https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/369961#M577917 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to know how I can create a Set Analysis that counts the active one for example:</P><P>I want to count the ID_ACC</P><P></P><P>Count( if (Date_End &gt;= Var_Date and Date_Start &lt;= Var_Date), ID_ACC)</P><P></P><P>Var_Date is a Variable calculated by a calendar</P><P>And Date_End and Date_Start are Dates in a table.</P><P></P><P>I will appreciate your help.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 26 Mar 2012 18:03:20 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/369961#M577917 2012-03-26T18:03:20Z Set Analysis - Help https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/369962#M577918 <HTML><HEAD></HEAD><BODY><P>I found a way to do this</P><P>by using this expression:</P><P></P><P>=Num(count(DISTINCT {&lt;DT_END = {"&gt;=$(#Var_Dat)"}, DT_START = {"&lt;=$(#Var_Dat)"}&gt;} ID_ACC),'#,##0')</P></BODY></HTML> Mon, 26 Mar 2012 20:36:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Help/m-p/369962#M577918 2012-03-26T20:36:42Z