QlikSense Count values with respect to dimension

[Oguzhan]

Hello,

I have a issue where i need to count a dimension Measurecode and if the dimension appears more than once I need to check the colum Notification. The value should be counted if the Measurecode appears more than once within the Notification.

So for example the count of Measurcode P01 is 5 but for the condition >1 is true only for notification 0011 & 0013 so i need QlikSense to display the KPI : 2 

Notification	Measurecode
0011	P01
0011	P01
0012	P11
0012	P01
0013	P01
0013	P01

[sunny_talwar]

May be this

Sum(Aggr(If(Count(Measurecode) > 1, 1, 0), Notification, Measurecode))

[Oguzhan]

Seems close but it doesnt work for my whole data. If I apply a filter the KPI doesn't show the correct number. 

Somehow i only need to count the 'P01' value I tried it like below but it always give the value 0

Sum(Aggr(If(Count({<Measurecode={'P01'}>},Measurecode) > 1, 1, 0), [Notification], Measurecode))

[sunny_talwar · Accepted solution]

You have an extra comma in place, try this

Sum(Aggr(
    If(Count({<Measurecode = {'P01'}>} Measurecode) > 1, 1, 0)
, [Notification], Measurecode))

[Oguzhan]

Thank you so much, works perfect!