Static filter in a table

[PhilippMUC]

Dear Community,

I have a little problem in Qlik Sense.

I have generated a table with only three columns that look something like this:

Client Name         Status                Contact Name
Client A                  Active                 John
Client B                  Not Active        John
Client C                  Not Active        Paul
Client D                  Active                Simon
Client E                  Active                John

I would like to set a static filter for the columns Status and Contact Name.

Filters:
- Status = Active
- Contact Name = John

If I open the sheet in Qlik Sense I only would like to see the Client Names where the Status is Active and the Contact Name is John. I have tried =MaxString({<Status = {"Active"}>}Status) but it does not give me the right results.

Any ideas?

Thanks a lot, 
Philipp

[Yoshidaqlik · Accepted solution]

Hi

in the dimension you want to bring the names of the clients, I think you can put a simple if

if(Status='Active',[Client Name])

if you want only the biggest one there you can do

Aggr(
	if(
		Rank(
			Count(if(Status='Active',[Contact Name]))
		,4)=1,
		[Contact Name]
	)
,[Contact Name])

regards

[PhilippMUC]

Thanks, it worked 🙂