topic Re: Section Application in QlikView

Section Application

Wed, 25 Nov 2020 16:16:04 GMT

i am using below script for data security but it is not working..looks behaving strange not able to trace out

please help me

Section Access;

LOAD * INLINE [

ACCESS, UPPER(NTNAME) as NTNAME, UPPER(DeveloperDesc) as DEVELOPERDESC

ADMIN, IMDAD\SA_QLIK_SVC_ACC, *

USER, IMDAD\USER_QPMC, ASHGHAL

USER, IMDAD\USER_PM, RAIL

];

Section Application;

Star is *;

LOAD ActualQuantity,

MaterialCategoryDesc,

UPPER(DeveloperDesc) as DEVELOPERDESC,

EstimatedQuantity,

ProjectDesc,

SelectDate

FROM

[\\CVW12PR-QVD01\ClusterSharedLocation\QVD\vw_DevelopersConsumption]

(qvd)where 1=1;

Re: Section Application

sureshsindhigi — Sun, 09 Apr 2017 17:36:30 GMT

Hi,

Can you please share your QVW file, which includs script to get more clarification. Thank you..

Regards,
Suresh Sindhigi.

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 02:56:34 GMT

Under Settings - Document Settings - Opening:

Check the checkbox named : Initial data reduction based on Section Access

Reload the document, save and close the instance completely and reopen.

Siva

Re: Section Application

Mon, 10 Apr 2017 03:45:07 GMT

i did this check box still no use

Re: Section Application

Mon, 10 Apr 2017 03:45:08 GMT

please find qvw

On Sun, Apr 9, 2017 at 8:36 PM, Suresh Sindhigi <qcwebmaster@qlikview.com>

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 03:51:49 GMT

what is hidden script password?

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 03:55:37 GMT

You didnt check the box.

Re: Section Application

Mon, 10 Apr 2017 03:57:34 GMT

QPMC

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 04:04:08 GMT

reload the attached file and save.

close all the qlikview instance completely and re open the dashboard.

Re: Section Application

Mon, 10 Apr 2017 04:10:15 GMT

but i see no changes you made to my script

Re: Section Application

Mon, 10 Apr 2017 04:29:00 GMT

after i add this fine i am not able to login to my application..can you tel me what changes you made..i dont see any changes to script

Re: Section Application

vardhancse — Mon, 10 Apr 2017 04:42:01 GMT

Hi,

I guess the issue is with the hidden script.

after adding the hidden script you need to run in the local system.

Please make sure that QV service accounts related to QMC were added in the users list.

Once the reload was successful in your local system, now try running in QMC.

Re: Section Application

satheshreddy — Mon, 10 Apr 2017 04:47:45 GMT

Hi Chenna,

why your write column names like that can you try like this.

ACCESS, NTNAME,DEVELOPERDESC

ADMIN,IMDAD\SA_QLIK_SVC_ACC,*

USER,IMDAD\USER_QPMC,ASHGHAL

USER,IMDAD\USER_PM,RAIL

Regards

S S

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 05:06:10 GMT

Channa Vunnam,

Try changing the script like this

ACCESS, NTNAME,DEVELOPERDESC

ADMIN,IMDAD\SA_QLIK_SVC_ACC,*

USER,IMDAD\USER_QPMC,ASHGHAL

USER,IMDAD\USER_PM,RAIL

and then make the checkbox as mentioned in the screenshot below

reload and save the application.

close all the qlikview instance completely and re open the dashboard.

Re: Section Application

Mon, 10 Apr 2017 06:03:07 GMT

i dont know what you did to the qvw but now i even not able to login to my application

Re: Section Application

Siva_Sankar — Mon, 10 Apr 2017 06:04:52 GMT

You no need to open the application i sent. Just do the changes that I mentioned above in your application.

Re: Section Application

jonathandienst — Mon, 10 Apr 2017 06:18:50 GMT

Section Access;

LOAD ACCESS, UPPER(NTNAME) as NTNAME, UPPER(DEVELOPERDESC) as DEVELOPERDESC

INLINE [

ACCESS, NTNAME, DEVELOPERDESC

ADMIN, IMDAD\SA_QLIK_SVC_ACC, *

USER, IMDAD\USER_QPMC, ASHGHAL

USER, IMDAD\USER_PM, RAIL

];

Re: Section Application

Mon, 10 Apr 2017 06:29:33 GMT

i did it after still it shows all data for USER_QPMC

On Mon, Apr 10, 2017 at 9:19 AM, Jonathan Dienst <qcwebmaster@qlikview.com>

Re: Section Application

satheshreddy — Mon, 10 Apr 2017 06:37:25 GMT

Hi Channa,

how its possible, it should work.

please clear and re create data, please use inline load wizard while creating time.

Regards

Sathish

Re: Section Application

Mon, 10 Apr 2017 06:40:56 GMT

I am not able to load data from QVD after i did this.