topic Re: How to map values in formula to another table in QlikView https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411970#M490659 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Just wanted to make sure if I understood it correctly. You have two tables - one with expressions and another table with the actual numbers. And you wanted to use the expressions from first table. Is this right? Not sure how you wanted to use the expressions. Please can you provide more explanation?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://www.QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sun, 14 Oct 2012 10:49:37 GMT IAMDV 2012-10-14T10:49:37Z How to map values in formula to another table https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411969#M490658 <HTML><HEAD></HEAD><BODY><P>I`ve got two tables, one of them has a column which contains expressions like (A_B_C)/(D_E_F) and (A_B_C)*(D_E_F).</P><P>Another table contains columns A,B,C,D,E,F that should match those from expressions. Please tell me, what`s the best way for me to do this?</P></BODY></HTML> Sun, 14 Oct 2012 10:24:20 GMT https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411969#M490658 2012-10-14T10:24:20Z Re: How to map values in formula to another table https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411970#M490659 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Just wanted to make sure if I understood it correctly. You have two tables - one with expressions and another table with the actual numbers. And you wanted to use the expressions from first table. Is this right? Not sure how you wanted to use the expressions. Please can you provide more explanation?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://www.QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sun, 14 Oct 2012 10:49:37 GMT https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411970#M490659 IAMDV 2012-10-14T10:49:37Z Re: How to map values in formula to another table https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411971#M490660 <HTML><HEAD></HEAD><BODY><P>Deepak, you are right, expressions in 1st table use actual numbers in second one (which is, actually, a crosstable).</P><P>As I said, expressions look like (A_B_C)/(D_E_F), where letters in expression (A_B_C) should match fields A and B in columns of the 2nd table, and C is a name of another column in 2nd table. Thus the actual number should be found.</P></BODY></HTML> Sun, 14 Oct 2012 11:07:45 GMT https://community.qlik.com/t5/QlikView/How-to-map-values-in-formula-to-another-table/m-p/411971#M490660 2012-10-14T11:07:45Z