https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775509#M454821 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6307">@johnan</a>&nbsp;</P><P>Try with Mod function</P><P>Load *,</P><P>Mod(Quantity, CasePack) as Needs,</P><P>If(Mod(Quantity, CasePack) = 0, 'False', 'True') as Result</P><P>From ursource;</P><P>Hope it helps</P> Tue, 19 Jan 2021 10:13:09 GMT MayilVahanan 2021-01-19T10:13:09Z https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775499#M454820 <P>Hi, i want to identify products that is not even to a casepack.<BR />Mydata:</P><P>Column Result and Needs is the data i want. Even better if a can choose True/False in a dimension.</P><TABLE><TBODY><TR><TD>SKU</TD><TD>Quant/CasePack</TD><TD>Quantity</TD><TD>CasePack&nbsp;</TD><TD>Result</TD><TD>Needs</TD></TR><TR><TD>253-7745801</TD><TD>0,166666667</TD><TD>1</TD><TD>6</TD><TD>True</TD><TD>1</TD></TR><TR><TD>253-7745801</TD><TD>0,166666667</TD><TD>1</TD><TD>6</TD><TD>True</TD><TD>1</TD></TR><TR><TD>253-7745801</TD><TD>1</TD><TD>6</TD><TD>6</TD><TD>False</TD><TD>0</TD></TR><TR><TD>253-7745801</TD><TD>1,333333333</TD><TD>8</TD><TD>6</TD><TD>True</TD><TD>2</TD></TR><TR><TD>253-7745801</TD><TD>2</TD><TD>12</TD><TD>6</TD><TD>False</TD><TD>0</TD></TR><TR><TD>253-7745801</TD><TD>2</TD><TD>12</TD><TD>6</TD><TD>False</TD><TD>0</TD></TR></TBODY></TABLE><P><BR />The Quant/CasePack is calculated in script.</P><P>Is this possible?</P><P>Br</P><P>John</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 19 Jan 2021 09:44:03 GMT https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775499#M454820 johnan 2021-01-19T09:44:03Z https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775509#M454821 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6307">@johnan</a>&nbsp;</P><P>Try with Mod function</P><P>Load *,</P><P>Mod(Quantity, CasePack) as Needs,</P><P>If(Mod(Quantity, CasePack) = 0, 'False', 'True') as Result</P><P>From ursource;</P><P>Hope it helps</P> Tue, 19 Jan 2021 10:13:09 GMT https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775509#M454821 MayilVahanan 2021-01-19T10:13:09Z https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775527#M454822 <P>This work perfect, a big thanks <SPAN class="UserName lia-user-name lia-user-rank-MVP"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="login-bold">MayilVahanan</SPAN></SPAN></SPAN></P> Tue, 19 Jan 2021 10:47:18 GMT https://community.qlik.com/t5/QlikView/ODD-EVEN-and-quantity/m-p/1775527#M454822 johnan 2021-01-19T10:47:18Z