topic How do I reverse engineering the table field in expression? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-reverse-engineering-the-table-field-in-expression/m-p/1427802#M816079 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>New to the forum and Qlikview. I have a Qlikview file that contains table field in expression. However, I am not able to find which table the field belongs to. Also, it applied to dimensional fields as well. How can I find which table the dimension fields belongs to? Can you please help?</P><P></P><P></P><P>Second question: is a field is constructed this way (not sure what it is) and on a pivot table has many column appears, how can I find the fields in tables? </P><P><SPAN style="font-size: 13.3333px;">=$(vFinanceAllLoan#)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks, </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">John <BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How do I reverse engineering the table field in expression? https://community.qlik.com/t5/QlikView/How-do-I-reverse-engineering-the-table-field-in-expression/m-p/1427802#M816079 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>New to the forum and Qlikview. I have a Qlikview file that contains table field in expression. However, I am not able to find which table the field belongs to. Also, it applied to dimensional fields as well. How can I find which table the dimension fields belongs to? Can you please help?</P><P></P><P></P><P>Second question: is a field is constructed this way (not sure what it is) and on a pivot table has many column appears, how can I find the fields in tables? </P><P><SPAN style="font-size: 13.3333px;">=$(vFinanceAllLoan#)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks, </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">John <BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-do-I-reverse-engineering-the-table-field-in-expression/m-p/1427802#M816079 Anonymous 2020-11-25T16:16:04Z Re: How do I reverse engineering the table field in expression? https://community.qlik.com/t5/QlikView/How-do-I-reverse-engineering-the-table-field-in-expression/m-p/1427803#M816080 <HTML><HEAD></HEAD><BODY><P>First Question - To know field where and/or which table. You could use QUALIFY statement over all dimensions.</P><P>Second Question - You can use $Field to know all fields from syntax </P></BODY></HTML> Mon, 04 Sep 2017 22:17:47 GMT https://community.qlik.com/t5/QlikView/How-do-I-reverse-engineering-the-table-field-in-expression/m-p/1427803#M816080 Anil_Babu_Samineni 2017-09-04T22:17:47Z