One of our customer has taken one document Qlikview license. That means all the reports have to be in one document. This will work as long as security is not in place. When we implement security we are getting issues./ Let me explain our scenario. We have some reports depends on Date , Location and Product. The some others are dependent on Date, Location, Supplier and Product. We want security to be implemented depending on the Location, Product and Supplier. Now For first set of reports we can implement security using username, access , Location_nam and Product_num. We should be able to security for second set of reports using username, access , Location_nam , Product_num and Supplier_num. That means we should be able to restrict data using two keys for first set of reports and using three keys for secod set of reports. Is this possible. What I experienced is we cannot have two separate set of security . Is that fine. Also note that in the above example I cannot combine both as for first set of reports supplier will not make any sense. Can you please help me on this. First question is whether something like this possible? If yes, Please let me now the solution. If No is it a limitation of QV? Let me attach my queries for you. First report: Absorption: Load "LOCATION_NAME", "LOCATION_NUM", "PRODUCT_NAME", PNO, "BUDGET_ABSORPTION", "BUDGET_PRODUCTION"; SQL SELECT * FROM ABSORPTION;
Second Report: Purchasing: Load "LOCATION_NAME", "LOCATION_NUM", PNO, "SUPPLIER_NUM", PRODUCT, "PURCHASE_COST", "PURCHASING_COST"; SQL SELECT * FROM PURCHASING;
