topic Partial Security in QlikView https://community.qlik.com/t5/QlikView/Partial-Security/m-p/306596#M113232 <HTML><HEAD></HEAD><BODY><P>I want to be able to filter by certain aspects for some reports, but not for others. Here's an example of what I need:</P><P></P><P>I have a table with a list of salespeople and their sales, with the following fields:</P><P></P><P>OfficeLocation</P><P>SalesPerson</P><P>Department</P><P>Sale_#</P><P>Items</P><P>SaleAmount</P><P>TotalCost</P><P>SaleProfit</P><P></P><P>Now, let's say I only want each sales person to be able to view their own sales. That's easy, I just set security by SalesPerson. However, I want each sales person to be able to see their Department total also - just not be able to dig deeper into that.</P><P></P><P>Is there a way to filter by SalesPerson for the detailed report (by sale #) but have a summary report that is only filtered by Department?</P></BODY></HTML> Tue, 21 Jun 2011 18:05:55 GMT danielact 2011-06-21T18:05:55Z Partial Security https://community.qlik.com/t5/QlikView/Partial-Security/m-p/306596#M113232 <HTML><HEAD></HEAD><BODY><P>I want to be able to filter by certain aspects for some reports, but not for others. Here's an example of what I need:</P><P></P><P>I have a table with a list of salespeople and their sales, with the following fields:</P><P></P><P>OfficeLocation</P><P>SalesPerson</P><P>Department</P><P>Sale_#</P><P>Items</P><P>SaleAmount</P><P>TotalCost</P><P>SaleProfit</P><P></P><P>Now, let's say I only want each sales person to be able to view their own sales. That's easy, I just set security by SalesPerson. However, I want each sales person to be able to see their Department total also - just not be able to dig deeper into that.</P><P></P><P>Is there a way to filter by SalesPerson for the detailed report (by sale #) but have a summary report that is only filtered by Department?</P></BODY></HTML> Tue, 21 Jun 2011 18:05:55 GMT https://community.qlik.com/t5/QlikView/Partial-Security/m-p/306596#M113232 danielact 2011-06-21T18:05:55Z Partial Security https://community.qlik.com/t5/QlikView/Partial-Security/m-p/306597#M113233 <HTML><HEAD></HEAD><BODY><P>No ideas on this one?</P></BODY></HTML> Wed, 22 Jun 2011 13:55:24 GMT https://community.qlik.com/t5/QlikView/Partial-Security/m-p/306597#M113233 danielact 2011-06-22T13:55:24Z