Direct Discovery show implicit fields values

mrybalko — Wed, 20 Mar 2013 17:30:57 GMT

Hello

Is it possible to show implicit field value?

For example I load table containing fields A and B.

ODBC CONNECT TO [Test_Excel;DBQ=H:\Direct.xlsx];
Direct:
Direct SELECT A
FROM `H:\Direct.xlsx`.`Лист1$`;

Field A is a key field, field B is an implicit text field. Then I want create chart: dimension A and expression B, but it does not work - null value is shown.

If I use count() function it shows correct value.

In attachment test qvw and excel.

Re: Direct Discovery show implicit fields values

mrybalko — Thu, 21 Mar 2013 17:24:02 GMT

Is is possible, but you should use any aggregation function which supports by odbc driver.

In above case work min() and max() functions.

topic Re: Direct Discovery show implicit fields values in QlikView

Direct Discovery show implicit fields values

Re: Direct Discovery show implicit fields values