topic Text Object Query in QlikView

topic Text Object Query in QlikView https://community.qlik.com/t5/QlikView/Text-Object-Query/m-p/1706476#M451493 <P>Hi,</P><P> </P><P>I do have the below table. </P><TABLE border="1" width="69.39727993576076%"><TBODY><TR><TD width="33.333333333333336%" height="24px">Country</TD><TD width="33.333333333333336%" height="24px">Total Cases</TD><TD width="16.666666666666668%" height="24px">No Cases</TD></TR><TR><TD height="24px">India</TD><TD height="24px">100</TD><TD height="24px">10</TD></TR><TR><TD width="33.333333333333336%" height="24px">Brazil</TD><TD width="33.333333333333336%" height="24px">200</TD><TD width="16.666666666666668%" height="24px">20</TD></TR></TBODY></TABLE><P> </P><P>My Requirement is i need an expression in text object which shows only Brazil Total Cases (i.e. 200)</P><P>Regards,</P><P>Bharath Vikas</P> Sat, 16 Nov 2024 00:34:54 GMT vikasshana 2024-11-16T00:34:54Z Text Object Query https://community.qlik.com/t5/QlikView/Text-Object-Query/m-p/1706476#M451493 <P>Hi,</P><P> </P><P>I do have the below table. </P><TABLE border="1" width="69.39727993576076%"><TBODY><TR><TD width="33.333333333333336%" height="24px">Country</TD><TD width="33.333333333333336%" height="24px">Total Cases</TD><TD width="16.666666666666668%" height="24px">No Cases</TD></TR><TR><TD height="24px">India</TD><TD height="24px">100</TD><TD height="24px">10</TD></TR><TR><TD width="33.333333333333336%" height="24px">Brazil</TD><TD width="33.333333333333336%" height="24px">200</TD><TD width="16.666666666666668%" height="24px">20</TD></TR></TBODY></TABLE><P> </P><P>My Requirement is i need an expression in text object which shows only Brazil Total Cases (i.e. 200)</P><P>Regards,</P><P>Bharath Vikas</P> Sat, 16 Nov 2024 00:34:54 GMT https://community.qlik.com/t5/QlikView/Text-Object-Query/m-p/1706476#M451493 vikasshana 2024-11-16T00:34:54Z Re: Text Object Query https://community.qlik.com/t5/QlikView/Text-Object-Query/m-p/1706507#M451497 <P>Hi,</P><P> </P><P>You can use Set Analysis for this.</P><P>=SUM({$<<SPAN>Country = {'Brazil'}</SPAN>>} [No Cases])</P> Fri, 29 May 2020 12:56:55 GMT https://community.qlik.com/t5/QlikView/Text-Object-Query/m-p/1706507#M451497 lujsantos 2020-05-29T12:56:55Z