topic Re: conditional connection ? in QlikView https://community.qlik.com/t5/QlikView/conditional-connection/m-p/833942#M1008205 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Perhaps you can use mapping tables and the applymap function in an if-statement. Or perhaps you can use the LookUp function with an if-statement. You can find more information about these functions in the help file and in this document: <A href="https://community.qlik.com/docs/DOC-3412">Joins and Lookups</A></P></BODY></HTML> Wed, 13 May 2015 08:52:58 GMT Gysbert_Wassenaar 2015-05-13T08:52:58Z conditional connection ? https://community.qlik.com/t5/QlikView/conditional-connection/m-p/833941#M1008204 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Guys, one interesting thing.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I would like to use conditional conection of data:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Field Origin:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sometimes it is refering to Stock.Move(table), 1 (value), sometimes to trytonlt_anglosaxon.line_move(table), 1 (value). I would like to connect these values and to reach the value in other tables. For example: If Origin is "stock.move,1" i want to connect to 1 value in Stock Move table, if it is "trytonlt_anglosaxon.line_move,1" I want to connect other table with it's value 1.</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-771851-86131/selection.tiff" style="font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="selection.tiff" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86155_selection.tiff" style="border: 0px; font-style: inherit; font-size: 10pt; font-family: inherit;" /></A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Earlier I was using </P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">subfield(origin,',',2) as [stock.move_value]</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">and it work<SPAN style="font-style: inherit; font-size: 10pt; font-family: inherit;">ing great, but only with one type of data. Any ideas?</SPAN></P></BODY></HTML> Mon, 11 May 2015 11:03:59 GMT https://community.qlik.com/t5/QlikView/conditional-connection/m-p/833941#M1008204 2015-05-11T11:03:59Z Re: conditional connection ? https://community.qlik.com/t5/QlikView/conditional-connection/m-p/833942#M1008205 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Perhaps you can use mapping tables and the applymap function in an if-statement. Or perhaps you can use the LookUp function with an if-statement. You can find more information about these functions in the help file and in this document: <A href="https://community.qlik.com/docs/DOC-3412">Joins and Lookups</A></P></BODY></HTML> Wed, 13 May 2015 08:52:58 GMT https://community.qlik.com/t5/QlikView/conditional-connection/m-p/833942#M1008205 Gysbert_Wassenaar 2015-05-13T08:52:58Z