Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

mrybalko
Contributor

Direct Discovery show implicit fields values

Hello

Is it possible to show implicit field value?

For example I load table containing fields A and B.

Буфер обмена-2.jpg

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.

Буфер обмена-1.jpg

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

In attachment test qvw and excel.

Tags (2)
1 Reply
mrybalko
Contributor

Re: Direct Discovery show implicit fields values

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

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

Community Browser