Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

carolin01
Contributor II

Section Access qvd field not found

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Section Access qvd field not found

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;

5 Replies
MVP
MVP

Re: Section Access qvd field not found

Could you post the full error message QV is showing?

carolin01
Contributor II

Re: Section Access qvd field not found

QV-Picture.jpg

MVP
MVP

Re: Section Access qvd field not found

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
Contributor II

Re: Section Access qvd field not found

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

andrejfreitas
New Contributor

Re: Section Access qvd field not found

Thank you!