Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks, it worked 🙂