topic Disregard the selection - set analysis in QlikView https://community.qlik.com/t5/QlikView/Disregard-the-selection-set-analysis/m-p/174548#M43332 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P>This is the exact formula i am using. I am trying to do a count of DateofService(this is the dimension) and a count when the ClaimsAmt&gt;0. But i need to disregard the selection. I know the basic {1} set analysis but i am not sure how to apply it to this formula.</P><P>=count(TOTAL Distinct if((DateofService&lt;=$(v_IBNRStDt)) AND ClaimsAmt&gt;0,DateofService,Null()))</P><P>Thanks.</P><BR /><BR /></BODY></HTML> Wed, 02 Jun 2010 22:05:32 GMT 2010-06-02T22:05:32Z Disregard the selection - set analysis https://community.qlik.com/t5/QlikView/Disregard-the-selection-set-analysis/m-p/174548#M43332 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P>This is the exact formula i am using. I am trying to do a count of DateofService(this is the dimension) and a count when the ClaimsAmt&gt;0. But i need to disregard the selection. I know the basic {1} set analysis but i am not sure how to apply it to this formula.</P><P>=count(TOTAL Distinct if((DateofService&lt;=$(v_IBNRStDt)) AND ClaimsAmt&gt;0,DateofService,Null()))</P><P>Thanks.</P><BR /><BR /></BODY></HTML> Wed, 02 Jun 2010 22:05:32 GMT https://community.qlik.com/t5/QlikView/Disregard-the-selection-set-analysis/m-p/174548#M43332 2010-06-02T22:05:32Z Disregard the selection - set analysis https://community.qlik.com/t5/QlikView/Disregard-the-selection-set-analysis/m-p/174549#M43333 <HTML><HEAD></HEAD><BODY><P>Set analysis can only be applied to aggregation functions... in this case you are using count().</P><P>You should be able to do something like this:<BR /></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=count({1} TOTAL Distinct if((DateofService&lt;=$(v_IBNRStDt)) AND ClaimsAmt&gt;0,DateofService,Null()))</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 03 Jun 2010 00:34:20 GMT https://community.qlik.com/t5/QlikView/Disregard-the-selection-set-analysis/m-p/174549#M43333 2010-06-03T00:34:20Z