Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter for one sheet

Hello everyone,

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 ?

Thank you.

Have a good day


4 Replies
Master III
Master III


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.

Not applicable

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.