How can I make my KPI respond only to a specific dimension

[yohanaerukala]

Hello, Is there a way in Qlik where I can restrict one of the KPI's in the dashboard respond only to a particular dimension and it shouldn't respond to any other dimensions in the model.

Here is the measure I'm using to calculate my KPI:

Count( distinct if([Database Database (Type)]='DB User' and Match([Database DB Status],'Active','New','Dropped','Not classified at this level'),[Database User Name OID]))

[Chanty4u]

Best way use alternate states

[marcus_sommer]

You may try an approach like:

count({1 < F1 = {'x'}, F2 = {'a', 'b', 'c'}, F3 = p(F3) >} distinct F4)

by using set analysis instead of if-loops.

[anat · Accepted solution]

try to bypass the filters which are not required to reflect

count({dim1,dim2< [Database Database (Type)]={'DB User'},[Database DB Status]={'Active','New','Dropped','Not classified at this level'}>}distinct  [Database User Name OID])