SECTION ACCESS - display only some tables depending on the user

[#1]

I have a QlikView that displays multiple sheets in the development of sales and purchases.

I need to see or only sales or only purchases depending on the user ...

then you can make "invisible" one sheet per user? if not, how should I do?

Thanks for your help.

[#2 · Accepted solution]

Along with the section access details add one more column named GROUP.

Now create another table after Section Application, having one column as GROUP and other columns as your SheetName. Under each SheetName give value as 0 or 1.

Now, go to the sheet properties. Select Show Sheet-->conditional. Give expression as Sum(SheetName)>=1

Also go to Document Properties--> Opening--> Initial Data Reduction Based on Section Access (checked)

See the post http://community.qlik.com/forums/t/20358.aspx. for one example

[#3]

perfect ..

thanks for the help ..