Security

[#1]

Hi All,

I have 3 tables Fact, PRFT,BAC I need to apply section access based on Region, Sub Region, Business Unit. Region, Sub Region is in PRFT table and Business Unit is in BAC table.

I have done coding (in second tab and commented)for this but it is working either Business unit or Region and sub Region. Could you please help me here

Thanks,

Chiru

[#2]

For use Section Access see this post:

https://community.qlik.com/docs/DOC-5917

Regards

Gennaro

[#3]

See the attachment

User this access login:

Admin      Admin123

Or

user          user123

[#4]

Hi Voto,

I am not able to open this QVW with Admin123 or user123.

Please help me here.

Thanks,

Chiru

[#5]

Use

User ID:   Admin

Password:  Admin123

or for reduce data

User ID:   user

Password:  user123

It works for me

[#6]

Yes Voto,

I am able to open QVW now.

But as per my requirement i will get all Region, Sub Region, BU from one QVD and DataValue contains all these values.

that's why i have created 2 seperate columns SECURITYKEY_BG,SECURITYKEY_REG and joined with PRFT,BAC table. Please have a look on commented code and give me some suggestion.

Thanks,

Chiru

[#7]

OK, can you provide me the source file   "Book1.xlsx"

so i can test load script.

[#8]

Hi Voto,

That contains data like below:

ACCESS,NTNAME,DATAVALUE

USER,apj\ttn,AMS

USER,apj\ssd,HPS

Thanks,

Chiru

[#9]

Hi Guys,

Any Ideas on this?

Thanks,

Chiru

[qlikviewwizard]

Hi Chiru,

Please check this thread.

Section Access