How do I reverse engineering the table field in expression?

[Anonymous]

Hi,

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?

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?

=$(vFinanceAllLoan#)

Thanks,

John

[Anil_Babu_Samineni]

First Question - To know field where and/or which table. You could use QUALIFY statement over all dimensions.

Second Question - You can use $Field to know all fields from syntax