topic Re: How to show record null values in QlikView https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816669#M660911 <HTML><HEAD></HEAD><BODY><P>If you want to show EMP 2 and 3 in a chart , SET Analysis can do this:</P><P></P><P>only( {$&lt;[Training Code]=e([Training Code])&gt; } [Training Code])</P><P></P><P>This will apply a filter to a chart to only show training codes in the set of codes that have NOT been selected.</P><P></P><P>Here is sample as well that works.</P></BODY></HTML> Mon, 02 Mar 2015 18:28:36 GMT JonnyPoole 2015-03-02T18:28:36Z How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816664#M660906 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i have a table like this below</P><TABLE border="1" class="jiveBorder" height="100" style="border: 1px solid rgb(0, 0, 0); width: 232px; height: 55px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Employee id</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Training Code</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">EST01</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">EST02</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">EST02</TD></TR></TBODY></TABLE><P></P><P></P><P>if i select from list box "EST01" i need show only employee 1 and 2</P><P>Is it possibile?</P><P></P><P>Tyvm</P><P>Simone</P></BODY></HTML> Mon, 02 Mar 2015 17:48:50 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816664#M660906 2015-03-02T17:48:50Z Re: How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816665#M660907 <HTML><HEAD></HEAD><BODY><P>What is the logic behind this? Please elaborate little more !</P></BODY></HTML> Mon, 02 Mar 2015 17:57:32 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816665#M660907 MK_QSL 2015-03-02T17:57:32Z Re: How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816666#M660908 <HTML><HEAD></HEAD><BODY><P>If You select <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">EST01 You only have employee 1.</SPAN></P></BODY></HTML> Mon, 02 Mar 2015 18:00:30 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816666#M660908 Anonymous 2015-03-02T18:00:30Z Re: How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816667#M660909 <HTML><HEAD></HEAD><BODY><P>My mistake.</P><P>i have to show only idEmp 2 and 3.</P></BODY></HTML> Mon, 02 Mar 2015 18:20:54 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816667#M660909 2015-03-02T18:20:54Z Re: How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816668#M660910 <HTML><HEAD></HEAD><BODY><P>so when you select EST01, you show the values that are not corresponding to EST01?</P></BODY></HTML> Mon, 02 Mar 2015 18:25:20 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816668#M660910 Anonymous 2015-03-02T18:25:20Z Re: How to show record null values https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816669#M660911 <HTML><HEAD></HEAD><BODY><P>If you want to show EMP 2 and 3 in a chart , SET Analysis can do this:</P><P></P><P>only( {$&lt;[Training Code]=e([Training Code])&gt; } [Training Code])</P><P></P><P>This will apply a filter to a chart to only show training codes in the set of codes that have NOT been selected.</P><P></P><P>Here is sample as well that works.</P></BODY></HTML> Mon, 02 Mar 2015 18:28:36 GMT https://community.qlik.com/t5/QlikView/How-to-show-record-null-values/m-p/816669#M660911 JonnyPoole 2015-03-02T18:28:36Z