Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@QlikSensor Maye be :
=count({<Dim={"= count({<Dim2={'M1'}>}Dim2)>1"}>} distinct Dim)/count (distinct Dim)
output:
@QlikSensor Maye be :
=count({<Dim={"= count({<Dim2={'M1'}>}Dim2)>1"}>} distinct Dim)/count (distinct Dim)
output:
Wow, thanks. Never would get that running without your help.