topic Re: The syn key disappeared in QlikView

The syn key disappeared

Wed, 25 Nov 2020 16:16:04 GMT

SECTION Access;

Directory;

load

upper('HK') as FILTER_CENTER_ID,

Upper(ACCESS) AS ACCESS,

Upper (NTNAME) AS NTNAME

// ROLE,

FROM

(ooxml, embedded labels, table is Sheet1);

////////////////////////////////////////////////

SECTION Application;

Directory;

LOAD

Upper (NTNAME) AS NTNAME,

Tab_Main

FROM

(ooxml, embedded labels, table is Sheet2);

////*******************************//

KEY_MASTER:

LOAD QA_center,

Office,

COO

FROM

(ooxml, embedded labels, table is Sheet1);

//**********Role Table**********//

ROLE_TABLE:

LOAD Distinct

Upper(QA_center) AS QA_center,

'ALL' AS FILTER_CENTER_ID

Resident KEY_MASTER;

LOAD Distinct

Upper(QA_center) AS "QA_center",

Upper(QA_center) AS FILTER_CENTER_ID

Resident KEY_MASTER;

Above is my code, the FILTER_CENTER_ID key just disappeared after the script is loaded, any ideas?thanks

Re: The syn key disappeared

qliksus — Wed, 27 Jul 2016 03:48:36 GMT

The Section access table wont be shown in the DataModel that's the reason . You can still the field in the ROLE_TABLE of your datamodel and this is the expected behavior

Re: The syn key disappeared

Wed, 27 Jul 2016 04:25:26 GMT

thanks for your reply dude, however it doesnt connect, the reducing field function not work as expected ;(

Re: The syn key disappeared

er_mohit — Wed, 27 Jul 2016 04:28:53 GMT

Hi,

This happen because of section access statement. Here, the access part will work internally and won't be appear on data model. To check the sync key try to comment section access and section application functions.

Hope it helps

Mohit

Re: The syn key disappeared

Wed, 27 Jul 2016 04:37:15 GMT

Sir, I had checked all but it still doesnt work, would you mind to have a look when you are free? Thanks

Re: The syn key disappeared

PrashantSangle — Wed, 27 Jul 2016 05:04:38 GMT

Hi,

are you talking about this code

ROLE_TABLE:

LOAD Distinct

Upper(QA_center) AS QA_center,

'ALL' AS FILTER_CENTER_ID

Resident KEY_MASTER;

LOAD Distinct

Upper(QA_center) AS "QA_center",

Upper(QA_center) AS FILTER_CENTER_ID

Resident KEY_MASTER;

In this script both table concatenated therefore you are not getting FILTER_CENTER_ID field as key.

other than this i don't find any table which link with Role_table with FILTER_CENTER_ID

Hope you got what you looking for.

Regards