topic Re: Section access for data and charts on same sheet..... in QlikView

Section access for data and charts on same sheet.....

saumyashah90 — Wed, 17 Apr 2013 10:38:47 GMT

I have 2 Questions

1) I have two tables Tab1 and Tab2,now i want USER1 to see only Tab1,USER2 to see only Tab2 and ADMIN to see both the tables.What should i do?(Kindly note both the tables are on same sheet).

2)I have one table name Tab1 which a field called "Region" ,now i want USER4 to see data only related to EUROPE and USER5 for all.What to do?

Re: Section access for data and charts on same sheet.....

nirav_bhimani — Wed, 17 Apr 2013 12:57:36 GMT

Hi,

If you want to show Tab1 to USER1 then try this expression in layout tab / conditional expression

If(QVUSER()='USER1 ',1,0)

Similary for Tab2 Use

If(QVUSER()='USER2 ',1,0)

Regards,

Nirav Bhimani

Re: Section access for data and charts on same sheet.....

nirav_bhimani — Thu, 18 Apr 2013 06:47:36 GMT

Hi,

Please find the attchment in this post.

Use user name as following and password also same.

User Password

ADMIN, ADMIN

USER1, USER1

USER2, USER2

USER3, USER3

Regards,

Nirav Bhimani