Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I loaded data from different tables of an Access file, and structured them in different tabs in Qlikview. Now I want to write a function in a Load statement in one tab, which uses a field in another tab. Then there's the error message 'field not found'. How can I set up the connection between 2 tabs? I appreciate any help from you.
Luwen
Hi Luwen
try changing the expression "from" to "resident" in the mapping code that will work.
Hey, Claudio!
I tried. But still 'field not found'......
Luwen
check which field name is throwing error by generating log file (document properties->Generate log file).
Check that field is exist in your database.
Hey, Sivaraj!
Yes, the fields that I am interested in are there. Just when I want to link them to the other table, they can not be found, I don't know why...
Luwen
Hi Lluwen
Try this
Thank you very much, Claudio!
According to your logic I used ApplyMap() in both Year() functions, then it works!
Luwen