How can this happen? TableViewer shows linkage where there's none?
Hi,
I just had something very strange, something that QlikView had never done before:
- I had an app with a master_calendar and one fact_table;
- The master_calendar has a date_field labeled %Datum;
- I loaded one field twice in the other table to have the same name ?=> QlikView linked them just like it should.
Now I added a third table which does have a date_field, but I rename all the fields in the script and it's then labeled "SPORD_%Datum". I will rework that now. But here's what happened:
The table_viewer showed me those three tables were linked through a field called SPORD_%Datum - all three of them.
And I wondered for a while why none of my charts would show any data - until I realized that that field actually exists in only one table, so the tables COULD NOT all be linked.
Are you doing the field renames with a RENAME FIELDS statement? If you are trying to rename a field to an existing name, the rename fails. Prior to some SR (7?) that failed silently with no script error. Could that explain your case?
yes, I am using a RENAME statement - in a loop so all the fields in that table are renamed (with a prefix to avoid any unwanted keys), but in that, I am not renaming them to any existing name. What I do is like qualifying the fields, just with a prefix that is a lot shorter than the table_name, which also makes the preview in the table_viewer more legible.
