Direct Discovery problem with extensions

jonoogle — Thu, 06 Aug 2015 02:45:55 GMT

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.

topic Direct Discovery problem with extensions in QlikView

Direct Discovery problem with extensions