Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Section Access table drops while reloading the application

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

4 Replies
maxgro
MVP
MVP

what if you comment section access?

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

jsanchezh
Partner - Creator
Partner - Creator

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;

vijetas42
Specialist
Specialist
Author

Hey,

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

THANKS!

vijetas42
Specialist
Specialist
Author

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