https://community.qlik.com/t5/App-Development/Show-value-if-different-to-selected/m-p/1707611#M54291 <P>Hello,</P><P>I need to get the values from D which are not assigned to a field in S:</P><TABLE width="192"><TBODY><TR><TD width="64">S</TD><TD width="64">A</TD><TD width="64">D</TD></TR><TR><TD>1</TD><TD>x</TD><TD>x1</TD></TR><TR><TD>1</TD><TD>x</TD><TD>x2</TD></TR><TR><TD>1</TD><TD>b</TD><TD>b3</TD></TR><TR><TD>2</TD><TD>b</TD><TD>b4</TD></TR><TR><TD>2</TD><TD>x</TD><TD>x5</TD></TR><TR><TD width="64">&nbsp;</TD><TD width="64">x</TD><TD width="64">x6</TD></TR><TR><TD width="64">&nbsp;</TD><TD width="64">x</TD><TD width="64">x7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Example:</P><P>- No S selected. Result --&gt; x6, x7 -Done: if( isnull(S),D)</P><P>-S=1 selected. Result --&gt;b4,x5,x6,x7&nbsp; - ?</P><P>-S=2 selected. Result --&gt; x1,x2,b3,x6,x7 - ?</P> Tue, 02 Jun 2020 20:48:32 GMT elinamcastelletta 2020-06-02T20:48:32Z https://community.qlik.com/t5/App-Development/Show-value-if-different-to-selected/m-p/1707611#M54291 <P>Hello,</P><P>I need to get the values from D which are not assigned to a field in S:</P><TABLE width="192"><TBODY><TR><TD width="64">S</TD><TD width="64">A</TD><TD width="64">D</TD></TR><TR><TD>1</TD><TD>x</TD><TD>x1</TD></TR><TR><TD>1</TD><TD>x</TD><TD>x2</TD></TR><TR><TD>1</TD><TD>b</TD><TD>b3</TD></TR><TR><TD>2</TD><TD>b</TD><TD>b4</TD></TR><TR><TD>2</TD><TD>x</TD><TD>x5</TD></TR><TR><TD width="64">&nbsp;</TD><TD width="64">x</TD><TD width="64">x6</TD></TR><TR><TD width="64">&nbsp;</TD><TD width="64">x</TD><TD width="64">x7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Example:</P><P>- No S selected. Result --&gt; x6, x7 -Done: if( isnull(S),D)</P><P>-S=1 selected. Result --&gt;b4,x5,x6,x7&nbsp; - ?</P><P>-S=2 selected. Result --&gt; x1,x2,b3,x6,x7 - ?</P> Tue, 02 Jun 2020 20:48:32 GMT https://community.qlik.com/t5/App-Development/Show-value-if-different-to-selected/m-p/1707611#M54291 elinamcastelletta 2020-06-02T20:48:32Z