topic Re: Finding Missing Values In Selection in QlikView https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417159#M1161883 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> PFA</P><P></P><P>Check the button?</P><P></P><P>use <STRONG>Select excluded</STRONG></P><P></P><P>Are you looking this?</P><P></P><P>Edit:</P><P>Check the file now. </P></BODY></HTML> Thu, 08 Nov 2012 15:16:15 GMT MayilVahanan 2012-11-08T15:16:15Z Finding Missing Values In Selection https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417158#M1161881 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm pasting ('|' separated) values into a variable which I then use to trigger a selection (see below). The question I have is - </P><P></P><P>Is there a way of generating a list of values in this variable list which are absent from the available values in the field list (i.e. missing in the selection)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="37" style="width: 900px; height: 37px;"><TBODY><TR><TD>(111111|222222|3333333|4444444|5555555|66666666|77777777|88888888|999999999|0000000000)</TD></TR></TBODY></TABLE><P></P><P>Many Thanks</P></BODY></HTML> Thu, 08 Nov 2012 15:07:23 GMT https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417158#M1161881 felix18807 2012-11-08T15:07:23Z Re: Finding Missing Values In Selection https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417159#M1161883 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> PFA</P><P></P><P>Check the button?</P><P></P><P>use <STRONG>Select excluded</STRONG></P><P></P><P>Are you looking this?</P><P></P><P>Edit:</P><P>Check the file now. </P></BODY></HTML> Thu, 08 Nov 2012 15:16:15 GMT https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417159#M1161883 MayilVahanan 2012-11-08T15:16:15Z Re: Finding Missing Values In Selection https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417160#M1161884 <HTML><HEAD></HEAD><BODY><P>See if the attached sheet is what you are looking for. </P></BODY></HTML> Thu, 08 Nov 2012 16:34:05 GMT https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417160#M1161884 2012-11-08T16:34:05Z Re: Finding Missing Values In Selection https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417161#M1161886 <HTML><HEAD></HEAD><BODY><P>Nice work rebeccad! </P><P></P><P>I have learned more than I asked by looking at this file. Many Thanks</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Fri, 09 Nov 2012 10:28:06 GMT https://community.qlik.com/t5/QlikView/Finding-Missing-Values-In-Selection/m-p/417161#M1161886 felix18807 2012-11-09T10:28:06Z