topic Check current selections of a sheet before adding a filter to current sheet. in QlikView

Check current selections of a sheet before adding a filter to current sheet.

ivandrago — Mon, 22 Oct 2012 21:42:38 GMT

Hi,

I have the attached document.

What I want it to do is when the "Users" sheet is activated I want it to check the "Main" sheet and see if the selection Dept = "IT" is one the "Current Selections", if it is I want it to removed from the Current Selections on "Users" sheet and then make the selection Dept - "Finance".

Thanks

Re: Check current selections of a sheet before adding a filter to current sheet.

MayilVahanan — Mon, 22 Oct 2012 21:48:50 GMT

Please check the attached file and let me know this you want??

Regards,

R.Mayil Vahanan

Re: Check current selections of a sheet before adding a filter to current sheet.

ivandrago — Mon, 22 Oct 2012 21:59:05 GMT

Nice work! Very clever!

Re: Check current selections of a sheet before adding a filter to current sheet.

ivandrago — Tue, 23 Oct 2012 09:24:45 GMT

Hi Mayil,

How do I make it select another field from another table?

So if Sales is Sleected, I want it to choose the City London when the "Users" Sheet is Activated.

Thanks

Re: Check current selections of a sheet before adding a filter to current sheet.

MayilVahanan — Tue, 23 Oct 2012 09:33:51 GMT

Hope you have link between two tables,

if so,

use like this

select in field: City

search string: =if(getfieldselecions(Sales)>0,'London','')

i didn't open the file.am in outside.. so oly.

Re: Check current selections of a sheet before adding a filter to current sheet.

ivandrago — Tue, 23 Oct 2012 10:51:18 GMT

Thanks Mayil, the epression did not work but I changed it to the following

=if(GetCurrentSelections('Sales')>0,'London','')