I am having a problem with Direct Discovery, QlikView 11 and extensions.
I have a SQL database that has a field "Country" and a field "text".
I then have an extension which accesses the "Country" field and passes it to a web service.
Country is a key which connects to another table loaded into QlikView.
When the Country is selected, the extension, which uses Country as its dimension, access the value of the Country in a similar manner:
this.Data.Rows[0][0]
If the country data is loaded using a Qlik load, the selected value is retrieved.
If the country data is loaded via DD, AND the Country name is not in the DD database, a dash "-" is found in the column. If the value is in the DD database, then the correct value is returned in the column.
What I don't understand is that the correct name is displayed in the chart where I am originally selecting the country, which indicates to me that Qlik has the correct value, and yet it is passing me a "-".
I could try to make a qvw which does this but it would be hard to make it functional without the DB connection.
