Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've inherited a Qlikview app that loaded multiple labels from the invoices. So as time went on and clients or articles changed names, the app would show multiple lines for a specific item or client because of its multiple labels.
The app uses a first qvw (we'll call it technical.qvw) to load the data from the two sources, then there is a binary load to the user app (we'll call this one user.qvw).
In my technical.qvw I've created three new tables with code and label for the three dimensions that have labels that seem to change over time. These tables are linked to the invoices table etc, and everything looks great in the technical.qvw, and tests out correctly.
The first line of the script in the user.qvw is a binary load of technical.qvw. Then there are a couple variables created and two adhoc tables. There is no section analysis.
Simple right? Mmmm, aparently not, because the three new tables are not showing up when the user.qvw is loaded.
What am I missing?
Thanks for your help!
If they are not in the table Viewer, thay are not loaded into user.qvw.
You have to reload technical.qvw first, save it and keep the same name.
Then do a reload of user.qvw, this is straight forward, should work.
Sounds ok, where do they not show up, in table Viewer? Because thats the only Place where you will find them.
The tables don't show up in table viewer, but more importantly the fields don't show up in the available fields for an object.
If they are not in the table Viewer, thay are not loaded into user.qvw.
You have to reload technical.qvw first, save it and keep the same name.
Then do a reload of user.qvw, this is straight forward, should work.
Arghg, I found my error, it was a dumb rookie mistake that I should have seen earlier!
I didn't change the path in the binary load to point to the test directory where I've been testing my changes.