topic Re: Count excluded values in QlikView https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652325#M238505 <HTML><HEAD></HEAD><BODY><P>visited + not visited is always 5?</P><P>not visited is all - visited</P><P>count({1-$} DateVisit)</P></BODY></HTML> Thu, 02 Oct 2014 20:12:31 GMT maxgro 2014-10-02T20:12:31Z Count excluded values https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652324#M238504 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have to show the number of customer visits by month and number of not visited customers. Because I have several facts (sales by customer and date,..) to show,&nbsp; it is necessary to make selections by year and month, but have to show the total number of not visited customers within a certain period (total 5 customers, 2 visited, 3 not visited).</P><P></P><P>Anyone has an idea?</P><P></P><P>Best regards</P></BODY></HTML> Thu, 02 Oct 2014 19:25:08 GMT https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652324#M238504 p_noindl 2014-10-02T19:25:08Z Re: Count excluded values https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652325#M238505 <HTML><HEAD></HEAD><BODY><P>visited + not visited is always 5?</P><P>not visited is all - visited</P><P>count({1-$} DateVisit)</P></BODY></HTML> Thu, 02 Oct 2014 20:12:31 GMT https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652325#M238505 maxgro 2014-10-02T20:12:31Z Re: Count excluded values https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652326#M238506 <HTML><HEAD></HEAD><BODY><P>Try expression below for not visited:</P><P></P><P>count({&lt;Year=,Month=,CustNo=E({$&lt;CustNo={"=count(DateVisit)&gt;0"}&gt;}CustNo)&gt;} DISTINCT CustNo)</P><P></P><P>or</P><P></P><P>count({&lt;Year=,Month=,CustNo=E(CustNo)&gt;} <SPAN style="font-size: 13.3333330154419px;">DISTINCT </SPAN>CustNo)</P></BODY></HTML> Thu, 02 Oct 2014 20:17:37 GMT https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652326#M238506 bgerchikov 2014-10-02T20:17:37Z Re: Count excluded values https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652327#M238507 <HTML><HEAD></HEAD><BODY><P>It worked, many thanks!</P></BODY></HTML> Thu, 02 Oct 2014 22:22:37 GMT https://community.qlik.com/t5/QlikView/Count-excluded-values/m-p/652327#M238507 p_noindl 2014-10-02T22:22:37Z