Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrybalko
Creator II
Creator II

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.

1 Reply
mrybalko
Creator II
Creator II
Author

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

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