topic Re: Transactions with different agents in App Development https://community.qlik.com/t5/App-Development/Transactions-with-different-agents/m-p/1806918#M65645 <P>You could use an if() function inside the count() function, like this:</P><P>=count(if([Agent A]=[Agent B],[RecordKey]))</P> Tue, 11 May 2021 11:13:35 GMT GaryGiles 2021-05-11T11:13:35Z Transactions with different agents https://community.qlik.com/t5/App-Development/Transactions-with-different-agents/m-p/1806831#M65638 <P>hi all</P><P>in my model I have two agents for every transaction. agents are coming from different tables in script.</P><P>in UI i want to present&nbsp; count of transactions that both agents are the same i.e:</P><TABLE><TBODY><TR><TD>Agent A</TD><TD>Agent B</TD><TD>RecordKey</TD><TD>CNT</TD></TR><TR><TD>D</TD><TD>A</TD><TD>293581</TD><TD>0</TD></TR><TR><TD>D</TD><TD>A</TD><TD>293591</TD><TD>0</TD></TR><TR><TD>D</TD><TD>A</TD><TD>293601</TD><TD>0</TD></TR><TR><TD>D</TD><TD>B</TD><TD>294711</TD><TD>0</TD></TR><TR><TD>D</TD><TD>B</TD><TD>294721</TD><TD>0</TD></TR><TR><TD>D</TD><TD>B</TD><TD>295161</TD><TD>0</TD></TR><TR><TD>D</TD><TD>B</TD><TD>295241</TD><TD>0</TD></TR><TR><TD>D</TD><TD>B</TD><TD>295431</TD><TD>0</TD></TR><TR><TD>D</TD><TD>C</TD><TD>295441</TD><TD>0</TD></TR><TR><TD>D</TD><TD>C</TD><TD>295731</TD><TD>0</TD></TR><TR><TD>D</TD><TD>C</TD><TD>295841</TD><TD>0</TD></TR><TR><TD>D</TD><TD>D</TD><TD>295851</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>296121</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>296351</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>296731</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>296771</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>296951</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>8208421</TD><TD>1</TD></TR><TR><TD>D</TD><TD>D</TD><TD>8209331</TD><TD>1</TD></TR><TR><TD>A</TD><TD>D</TD><TD>8210241</TD><TD>0</TD></TR><TR><TD>A</TD><TD>D</TD><TD>8211151</TD><TD>0</TD></TR><TR><TD>A</TD><TD>D</TD><TD>8212061</TD><TD>0</TD></TR><TR><TD>A</TD><TD>B</TD><TD>8212971</TD><TD>0</TD></TR><TR><TD>A</TD><TD>B</TD><TD>8213881</TD><TD>0</TD></TR><TR><TD>A</TD><TD>B</TD><TD>8214791</TD><TD>0</TD></TR><TR><TD>A</TD><TD>B</TD><TD>8215701</TD><TD>0</TD></TR><TR><TD>A</TD><TD>B</TD><TD>8216611</TD><TD>0</TD></TR><TR><TD>A</TD><TD>C</TD><TD>8217521</TD><TD>0</TD></TR><TR><TD>A</TD><TD>C</TD><TD>8218431</TD><TD>0</TD></TR><TR><TD>A</TD><TD>C</TD><TD>8219341</TD><TD>0</TD></TR><TR><TD>A</TD><TD>A</TD><TD>8220251</TD><TD>1</TD></TR><TR><TD>A</TD><TD>A</TD><TD>8221161</TD><TD>1</TD></TR><TR><TD>A</TD><TD>A</TD><TD>8222071</TD><TD>1</TD></TR><TR><TD>A</TD><TD>A</TD><TD>8222981</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>any ideas ?</P><P>&nbsp;</P><P>advanced thanks</P> Tue, 11 May 2021 07:42:47 GMT https://community.qlik.com/t5/App-Development/Transactions-with-different-agents/m-p/1806831#M65638 ilanbaruch 2021-05-11T07:42:47Z Re: Transactions with different agents https://community.qlik.com/t5/App-Development/Transactions-with-different-agents/m-p/1806918#M65645 <P>You could use an if() function inside the count() function, like this:</P><P>=count(if([Agent A]=[Agent B],[RecordKey]))</P> Tue, 11 May 2021 11:13:35 GMT https://community.qlik.com/t5/App-Development/Transactions-with-different-agents/m-p/1806918#M65645 GaryGiles 2021-05-11T11:13:35Z