https://community.qlik.com/t5/App-Development/Script-help/m-p/2505265#M103929 <P>Hi, I have data like below.</P> <P>I want to show the Products for ID's where Product ='Apple' as null().</P> <P>In this below example ID =1 has both Apple and Banana so I want to show null. Please see the below "Required output" column.</P> <P>&nbsp;</P> <TABLE width="275"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="211">Product</TD> </TR> <TR> <TD>1</TD> <TD>Apple</TD> </TR> <TR> <TD>1</TD> <TD>Banana</TD> </TR> <TR> <TD>3</TD> <TD>orange</TD> </TR> <TR> <TD>4</TD> <TD>carrot</TD> </TR> <TR> <TD>5</TD> <TD>Apple</TD> </TR> <TR> <TD>5</TD> <TD>Pineapple</TD> </TR> <TR> <TD>6</TD> <TD>Apple</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD colspan="2"><STRONG>Required Output</STRONG></TD> </TR> <TR> <TD>ID</TD> <TD>Product</TD> </TR> <TR> <TD>1</TD> <TD><STRONG>null()</STRONG></TD> </TR> <TR> <TD>3</TD> <TD>orange</TD> </TR> <TR> <TD>4</TD> <TD>carrot</TD> </TR> <TR> <TD>5</TD> <TD><STRONG>null()</STRONG></TD> </TR> <TR> <TD>6</TD> <TD><STRONG>null()</STRONG></TD> </TR> </TBODY> </TABLE> Tue, 11 Feb 2025 03:01:40 GMT Krish2459_58 2025-02-11T03:01:40Z https://community.qlik.com/t5/App-Development/Script-help/m-p/2505265#M103929 <P>Hi, I have data like below.</P> <P>I want to show the Products for ID's where Product ='Apple' as null().</P> <P>In this below example ID =1 has both Apple and Banana so I want to show null. Please see the below "Required output" column.</P> <P>&nbsp;</P> <TABLE width="275"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="211">Product</TD> </TR> <TR> <TD>1</TD> <TD>Apple</TD> </TR> <TR> <TD>1</TD> <TD>Banana</TD> </TR> <TR> <TD>3</TD> <TD>orange</TD> </TR> <TR> <TD>4</TD> <TD>carrot</TD> </TR> <TR> <TD>5</TD> <TD>Apple</TD> </TR> <TR> <TD>5</TD> <TD>Pineapple</TD> </TR> <TR> <TD>6</TD> <TD>Apple</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD colspan="2"><STRONG>Required Output</STRONG></TD> </TR> <TR> <TD>ID</TD> <TD>Product</TD> </TR> <TR> <TD>1</TD> <TD><STRONG>null()</STRONG></TD> </TR> <TR> <TD>3</TD> <TD>orange</TD> </TR> <TR> <TD>4</TD> <TD>carrot</TD> </TR> <TR> <TD>5</TD> <TD><STRONG>null()</STRONG></TD> </TR> <TR> <TD>6</TD> <TD><STRONG>null()</STRONG></TD> </TR> </TBODY> </TABLE> Tue, 11 Feb 2025 03:01:40 GMT https://community.qlik.com/t5/App-Development/Script-help/m-p/2505265#M103929 Krish2459_58 2025-02-11T03:01:40Z https://community.qlik.com/t5/App-Development/Script-help/m-p/2505276#M103931 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/175513">@Krish2459_58</a>&nbsp;</P> <P>Normal Table &gt; ID as Dimension and then below is the measure&nbsp;</P> <LI-CODE lang="markup">IF(Count(distinct Product) &gt; 1, 'Null()', Product)</LI-CODE> <P>I'm just not understanding why ID 6 is null on your output table?&nbsp;</P> <P>Regards Jandre</P> Tue, 11 Feb 2025 06:39:02 GMT https://community.qlik.com/t5/App-Development/Script-help/m-p/2505276#M103931 JandreKillianRIC 2025-02-11T06:39:02Z https://community.qlik.com/t5/App-Development/Script-help/m-p/2505414#M103943 <P>Try this&nbsp;</P> <P>If(Aggr(Count({&lt;Product={'Apple'}&gt;} Product), ID) &gt; 0, Null(), Product)</P> <P>&nbsp;</P> Tue, 11 Feb 2025 16:25:45 GMT https://community.qlik.com/t5/App-Development/Script-help/m-p/2505414#M103943 Chanty4u 2025-02-11T16:25:45Z