topic use count set analysis to determine values on one getfieldselection not in value from another getfieldselections in QlikView https://community.qlik.com/t5/QlikView/use-count-set-analysis-to-determine-values-on-one/m-p/1339730#M617499 <HTML><HEAD></HEAD><BODY><P>HELP!!! I have two separate date selection boxes ( <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1 </SPAN>and&nbsp; PURCHASE_DATE2). </P><P>Given the Purchase Date selection below</P><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #92d050;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P>I need to use set analysis expression to identify the count of customers from <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN> NOT on <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN>.</P><P>In this case the result is 2 (customer DD and EE). </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 446px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">customer1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">customer2</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">DD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">EE</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">FF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Apr 2017 17:22:33 GMT shawnqlikfv 2017-04-28T17:22:33Z use count set analysis to determine values on one getfieldselection not in value from another getfieldselections https://community.qlik.com/t5/QlikView/use-count-set-analysis-to-determine-values-on-one/m-p/1339730#M617499 <HTML><HEAD></HEAD><BODY><P>HELP!!! I have two separate date selection boxes ( <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1 </SPAN>and&nbsp; PURCHASE_DATE2). </P><P>Given the Purchase Date selection below</P><P> <SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #92d050;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P>I need to use set analysis expression to identify the count of customers from <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN> NOT on <SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN>.</P><P>In this case the result is 2 (customer DD and EE). </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 446px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">customer1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE1</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">customer2</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="119"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PURCHASE_DATE2</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Jan-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AA</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">DD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BB</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">EE</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Feb-16</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CC</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">FF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mar-16</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Apr 2017 17:22:33 GMT https://community.qlik.com/t5/QlikView/use-count-set-analysis-to-determine-values-on-one/m-p/1339730#M617499 shawnqlikfv 2017-04-28T17:22:33Z