Access point is asking some users to sign in twice. After they enter login credentials then click on the Report Module and it asks to enter login credentials again.

[neena123]

It does this for IE and for Chrome.  Any help is appreciated!

[neena123]

Section Access;

Load

                Upper(SERIAL) as SERIAL,

                Upper(ACCESS) as ACCESS,

                Upper(NTNAME) as NTNAME,

                //Upper(PASSWORD) as PASSWORD,

                Upper(COMPANY) as COMPANY,

                Upper(SHEET) as SHEET

FROM "…..xls" (biff, embedded labels, table is [Security$])

WHERE COMPANY = '$(BusinessUnitLimit)' OR Upper(COMPANY) = 'ALL';

Section Application;

OrderTypeLimit:

Load

                [Order Type],

                Upper(ORDERTYPELIMIT) as ORDERTYPELIMIT

FROM "…xls" (biff, embedded labels, table is [Order Type Limit$])

WHERE EXISTS([Order Type]);

SheetSecurity:

Load DISTINCT

                SHEET,

                SHEET as Sheet

FROM "…xls" (biff, embedded labels, table is [Security$]);

[#3 · Accepted solution]

Neena,

Watch this video on QlikView Section Access: QVInPractice2_SectionAccess.mp4 - Google Drive

jg

[neena123]

Thank you!

[#5]

Neena,  if the video was helpful or answered your question, please mark that reply with helpful / answered so that others may benefit from your questions.

Thanks,

Jeff G