topic Lookup a caption from table in QlikView https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148324#M26644 <HTML><HEAD></HEAD><BODY><P>Your solution needs to have one value returned. Try this:</P><P>=</P><P></P>Maxstring(If([Object Name] = 'Name1',[Caption])) <BR /><BR /></BODY></HTML> Fri, 03 Jul 2009 00:59:10 GMT Anonymous 2009-07-03T00:59:10Z Lookup a caption from table https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148323#M26643 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I'm trying to get a caption for a text object from a simple table. E.g.</P><P><STRONG>Object Name Caption</STRONG></P><P>Name1 Caption for name 1</P><P>Name2 Caption for name 2</P><P></P><P>What should the expression be? I've tried</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=(if([Object Name]='Name1',[Caption],0))</PRE><BR /><BR /> <P>But that didn't work... Somehow I need to search through the table?</P><P>Your help will be appreciated!</P><P>Eon</P><BR /><BR /></BODY></HTML> Thu, 02 Jul 2009 18:19:08 GMT https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148323#M26643 alerse 2009-07-02T18:19:08Z Lookup a caption from table https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148324#M26644 <HTML><HEAD></HEAD><BODY><P>Your solution needs to have one value returned. Try this:</P><P>=</P><P></P>Maxstring(If([Object Name] = 'Name1',[Caption])) <BR /><BR /></BODY></HTML> Fri, 03 Jul 2009 00:59:10 GMT https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148324#M26644 Anonymous 2009-07-03T00:59:10Z Lookup a caption from table https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148325#M26645 <HTML><HEAD></HEAD><BODY><P>perfect, thanks so much!!</P></BODY></HTML> Fri, 03 Jul 2009 11:45:51 GMT https://community.qlik.com/t5/QlikView/Lookup-a-caption-from-table/m-p/148325#M26645 alerse 2009-07-03T11:45:51Z