Discussion Board for collaboration related to QlikView App Development.
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 AFROM `H:\Direct.xlsx`.`Лист1$`;
ODBC CONNECT TO [Test_Excel;DBQ=H:\Direct.xlsx];
Direct SELECT A
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.
Is is possible, but you should use any aggregation function which supports by odbc driver.
In above case work min() and max() functions.