topic Re: Section Access table drops while reloading the application in QlikView

Section Access table drops while reloading the application

vijetas42 — Mon, 30 Mar 2015 15:23:47 GMT

Hi All,

Below is the table structure of the section access table. After creating the QVD of the table, when i am trying to reload the application the section table drops and i am not able to open the document on access point.

Section table Structure:

SECTION Access;

LOAD upper(ACCESS_TYPE) AS ACCESS,

NTNAME,

GROUP_ID,

FROM

[$(vQVDPath)\QV_ACCESS.qvd]

(qvd);

SECTION Application;

Your quick response would be highly appreciated.

Thanks

Re: Section Access table drops while reloading the application

maxgro — Mon, 30 Mar 2015 15:57:21 GMT

what if you comment section access?

do you get the table with access, ntname and group_id?

Re: Section Access table drops while reloading the application

jsanchezh — Mon, 30 Mar 2015 16:03:23 GMT

I might be wrong, but I think you made a syntax mistake after GROUP_ID you don't have to write a comma (,)

SECTION Access;

LOAD upper(ACCESS_TYPE) AS ACCESS,

NTNAME,

GROUP_ID

FROM

[$(vQVDPath)\QV_ACCESS.qvd]

(qvd);

SECTION Application;

Re: Section Access table drops while reloading the application

vijetas42 — Mon, 30 Mar 2015 16:12:37 GMT

Hey,

It was typing mistake in my script there is no any comma after GROUP ID

THANKS!

Re: Section Access table drops while reloading the application

vijetas42 — Mon, 30 Mar 2015 16:16:40 GMT

Yes, If I comment out the "Section Access" part, I can view the column in the table