topic Re: two separate filter for same application in QlikView

two separate filter for same application

Anonymous — Thu, 20 Jun 2013 11:31:03 GMT

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

Re: two separate filter for same application

sivarajs — Thu, 20 Jun 2013 11:35:12 GMT

Go with section access to filter the data

Re: two separate filter for same application

Thu, 20 Jun 2013 11:50:03 GMT

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