Discussion Board for collaboration on QlikView Scripting.
I´m trying to load from a qvd to apply for a section 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)
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!
Go to Solution.
I think you need to state the field names also in UPPER case, even when the source shows mixed or lower case field names:
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
Could you post the full error message QV is showing?
This is correct! :-) I also had to upper the fields in the connected tables and now it works. Many thanks!