topic Re: Filter for one sheet in QlikView

Filter for one sheet

Mon, 02 Feb 2015 09:04:18 GMT

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

Laura

Re: Filter for one sheet

arulsettu — Mon, 02 Feb 2015 09:08:00 GMT

check this

QlikView App - Show and Hide Sheets based on User or Menu

Re: Filter for one sheet

alexandros17 — Mon, 02 Feb 2015 09:08:48 GMT

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

Re: Filter for one sheet

avinashelite — Mon, 02 Feb 2015 09:45:56 GMT

Hi,

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.

Re: Filter for one sheet

Thu, 14 Jul 2016 22:37:57 GMT

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.