topic show the updated details where rows are not matching in App Development https://community.qlik.com/t5/App-Development/show-the-updated-details-where-rows-are-not-matching/m-p/1694801#M53136 <P>Hi Qlik Experts,</P><P>I am struck with one scenario where i need to show unmatched columns details if rows are not matching.</P><P>Please have a look into below table for more clearing:</P><P>&nbsp;</P><TABLE width="870"><TBODY><TR><TD width="72">&nbsp;</TD><TD width="58">Input</TD><TD width="42">&nbsp;</TD><TD width="65">&nbsp;</TD><TD width="185">&nbsp;</TD><TD width="79">&nbsp;</TD><TD width="79">&nbsp;</TD><TD width="56">&nbsp;</TD><TD width="78">Output</TD><TD width="81">&nbsp;</TD><TD width="75">&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Deal NO</TD><TD>Unit</TD><TD>Payment&nbsp;</TD><TD>Event Deal Tracking Number</TD><TD>Ins Type</TD><TD>Toll Set</TD><TD>Buy Sell</TD><TD>Field Name</TD><TD>Old Value</TD><TD>New Value</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Invest</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Invest</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>Payment&nbsp;</TD><TD>Invest</TD><TD>Price</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Price</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>Unit</TD><TD>PTL</TD><TD>BBL</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>BBL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>Ins Type</TD><TD>Comm-Phys</TD><TD>Comm-Fee</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Condition:</TD><TD>we should show output where the rows are different for each deal number&nbsp; if rows are matching no need to show</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help with your valuable suggestions.</P><P>Thanks in Advance..!!</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 Apr 2020 07:25:39 GMT manojkumar_mk 2020-04-20T07:25:39Z show the updated details where rows are not matching https://community.qlik.com/t5/App-Development/show-the-updated-details-where-rows-are-not-matching/m-p/1694801#M53136 <P>Hi Qlik Experts,</P><P>I am struck with one scenario where i need to show unmatched columns details if rows are not matching.</P><P>Please have a look into below table for more clearing:</P><P>&nbsp;</P><TABLE width="870"><TBODY><TR><TD width="72">&nbsp;</TD><TD width="58">Input</TD><TD width="42">&nbsp;</TD><TD width="65">&nbsp;</TD><TD width="185">&nbsp;</TD><TD width="79">&nbsp;</TD><TD width="79">&nbsp;</TD><TD width="56">&nbsp;</TD><TD width="78">Output</TD><TD width="81">&nbsp;</TD><TD width="75">&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Deal NO</TD><TD>Unit</TD><TD>Payment&nbsp;</TD><TD>Event Deal Tracking Number</TD><TD>Ins Type</TD><TD>Toll Set</TD><TD>Buy Sell</TD><TD>Field Name</TD><TD>Old Value</TD><TD>New Value</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Invest</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Invest</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>Payment&nbsp;</TD><TD>Invest</TD><TD>Price</TD></TR><TR><TD>&nbsp;</TD><TD>1011</TD><TD>BBL</TD><TD>Price</TD><TD>3768</TD><TD>Commodity</TD><TD>Comopt</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>PTL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>Unit</TD><TD>PTL</TD><TD>BBL</TD></TR><TR><TD>&nbsp;</TD><TD>2022</TD><TD>BBL</TD><TD>Interest</TD><TD>78643</TD><TD>EO-Call</TD><TD>Commodity</TD><TD>Buy</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Phys</TD><TD>CommFut</TD><TD>Sell</TD><TD>Ins Type</TD><TD>Comm-Phys</TD><TD>Comm-Fee</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5467</TD><TD>PTLCL</TD><TD>Premium</TD><TD>65732</TD><TD>Comm-Fee</TD><TD>CommFut</TD><TD>Sell</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Condition:</TD><TD>we should show output where the rows are different for each deal number&nbsp; if rows are matching no need to show</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help with your valuable suggestions.</P><P>Thanks in Advance..!!</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 Apr 2020 07:25:39 GMT https://community.qlik.com/t5/App-Development/show-the-updated-details-where-rows-are-not-matching/m-p/1694801#M53136 manojkumar_mk 2020-04-20T07:25:39Z