Discussion Board for collaboration related to QlikView App Development.
I have a QV application with several sheets which contains tables/graphs ... about several clients.
I would like one of the sheets to be filtered on only one client. Is there a simple way to do it ? Or do I have to put set analysis or if conditions in each object of this sheet ?
Have a good day
QlikView App - Show and Hide Sheets based on User or Menu
You could use alternate states on the objects of that sheet but ... there is an easyer way:
When you enter that sheet use a trigger to filter the client, when you leave that sheet, delete the selections:
Right Click on the sheet -> properties -> triggers - > add actions -> add -> Selections and select in field then
on the upper box write the field name, in the lower bow write the value you want to filer (The client name)
let me know
if its for several clients then i would suggest to do that using section access, this is the best way to implement security.
Based on the logged in user, it will provide access for the respective user.
This did the trick for me, thank you! I was able to apply three selections when activating the sheet and then clear all selections upon leaving.