Count a field dependent on a measure

[QlikSensor]

Hi,

I want to count a dimension only if a measure has a certain condition. Then I want to build a KPI.

Let's say our dimension is called Dim, and our measure is built on another Dimension Dim2.

I want to design a KPI like this:

count( {setEpression} distinct Dim) / count (distinct Dim)

Example Table:

Dim    Dim2

Val1   M1

Val1   M1

Val2  M1

Val2  M2

Val3 M1

The setExpression shall take only Dim values into account, if there are more than one M1 values on Dim2. In the table example above I would expect my KPI to evaluate to 1 / 3

I have no clue, how the setExpression has to look like.

[Taoufiq_Zarra · Accepted solution]

@QlikSensor  Maye be :

=count({<Dim={"= count({<Dim2={'M1'}>}Dim2)>1"}>}  distinct Dim)/count (distinct Dim)

output:

[QlikSensor]

Wow, thanks. Never would get that running without your help.