topic QlikSense Count values with respect to dimension in App Development

QlikSense Count values with respect to dimension

Oguzhan — Sat, 16 Nov 2024 18:07:48 GMT

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

Re: QlikSense Count values with respect to dimension

sunny_talwar — Wed, 09 Sep 2020 13:43:41 GMT

May be this

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

Re: QlikSense Count values with respect to dimension

Oguzhan — Thu, 10 Sep 2020 07:07:42 GMT

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))

Re: QlikSense Count values with respect to dimension

sunny_talwar — Thu, 10 Sep 2020 12:06:50 GMT

You have an extra comma in place, try this

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

Re: QlikSense Count values with respect to dimension

Oguzhan — Thu, 10 Sep 2020 12:10:55 GMT

Thank you so much, works perfect!