Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anutosh_dhar
Contributor

two separate filter for same application

I have two users one can view sales chart other can view purchase chart.

How can i do this ?

is it the right approach to make it indirect set analysis?

if user A logged in then he can able to see-sales chart

if user B logged in then he can able to see-purchase chart

2 Replies
sivarajs
Valued Contributor II

Re: two separate filter for same application

Go with section access to filter the data

Not applicable

Re: two separate filter for same application

Hi ,
Yes u can try This

Create a security table

Please find below tables ;

Example

Table:
Load

User Name  SHEET1  SHEET2  
*                    1             1

User1             1             0

User2             0             1

Left join

Load
ACCESS  USERID   PASSWORD UserName  Group          
SheetView       
ADMIN   qvadmin    123                  *               ADMIN            
*
USER   *                 *                   User1          Sales        
SHEET1              
USER   *                 *                    User2         Purchase  
SHEET2     

Sheet 1  for view Sales chart.

Sheet 2  for view purchase chart.

Hope above Table will work.

Regards-Bika

Community Browser