topic Section Access qvd field not found in QlikView

Section Access qvd field not found

carolin01 — Fri, 05 Feb 2016 13:22:30 GMT

Hi,

I´m trying to load from a qvd to apply for a section access:

SECTION Access;

LOAD

NTNAME,

ACCESS,

Upper(UserFullName) as UserFullName,

upper(SoldToBusinessPartner.ExternalSalesRepName) as SoldToBusinessPartner.ExternalSalesRepName,

upper(AreaSalesManagerName) as AreaSalesManagerName,

upper(GeneralManagerName) as GeneralManagerName,

upper(GlobalRegion) as GlobalRegion,

upper(SheetFlagTest) as SheetFlagTest

FROM $(vQVDPath)\SecurityFile.qvd (qvd)

where 1=1;

Section Application;

If I do this then it tells me that my first field is not found in the qvd although it is there and exists. What do I do wrong?

Many thanks in advance!

swuehl — Fri, 05 Feb 2016 13:27:17 GMT

Could you post the full error message QV is showing?

carolin01 — Fri, 05 Feb 2016 13:33:41 GMT

swuehl — Fri, 05 Feb 2016 13:48:04 GMT

I think you need to state the field names also in UPPER case, even when the source shows mixed or lower case field names:

SECTION Access;

LOAD

NTNAME,

ACCESS,

Upper(USERFULLNAME) as USERFULLNAME,

upper(SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME) as SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME,

upper(AREASALESMANAGERNAME) as AREASALESMANAGERNAME,

upper(GENERALMANAGERNAME) as GENERALMANAGERNAME,

upper(GLOBALREGION) as GLOBALREGION,

upper(SHEETFLAGTEST) as SHEETFLAGTEST

FROM $(vQVDPath)\SecurityFile.qvd (qvd)

where 1=1;

carolin01 — Fri, 05 Feb 2016 13:55:03 GMT

This is correct! 🙂 I also had to upper the fields in the connected tables and now it works. Many thanks!

andrejfreitas — Fri, 09 Mar 2018 11:17:34 GMT

Thank you!