Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
You have an extra comma in place, try this
Sum(Aggr(
If(Count({<Measurecode = {'P01'}>} Measurecode) > 1, 1, 0)
, [Notification], Measurecode))
May be this
Sum(Aggr(If(Count(Measurecode) > 1, 1, 0), Notification, Measurecode))
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))
You have an extra comma in place, try this
Sum(Aggr(
If(Count({<Measurecode = {'P01'}>} Measurecode) > 1, 1, 0)
, [Notification], Measurecode))
Thank you so much, works perfect!