Make a KPI with values

[Anonymous]

Hey there,

I got a problem on making a KPI. I want to show a KPI which shows a count how many distinct BBDs (Best Before Date) (see table below) are higher than 1. So in the case from the table below it should display 6, because the count higher than 1 is 6.

I tried to make a count(if(count( formula but it al did not give me the right KPI. I run into the problem that I can't use the BBD in the formula, because this is a distinct count value I am making from more BBDs. So $$Prinartsubnr is a dimension and BBD a distinct count from all BBDs, making it a value and which makes it unusable for my KPI (in my opinion)

I have tried to make some sort of formula in my load too, but I couldn't.

$$Prinartsubnr	BBD
6000|4031289|1-127	6
6000|4055368|1-5600814694	5
6000|4045796|1-360428	3
6000|4055368|1-18000479	3
6090|0340029968|1-180603	2
6090|0340034411|1-823B92VT14	2
6000|20995|1-8003690658	1
6000|20995|1-8003706199	1
6000|22714|1-L8163	1
6000|22714|1-L8166	1

I am still learning a lot in Qlik and hope you can help me out or send me in the right direction. At the moment I am really stuck on this one.

Thanks in advance,

Paul.

[Anonymous]

How can I extract that from qliksense?

[Anonymous]

From where I am working I can't extract unfortunately.

[Anonymous]

Thanks all for the reactions, but don't have the solution yet. Anyone with a solution?

[sasikanth]

Try this,

=Sum(Aggr(Count({<$$Prinartsubnr ={"=count(Distinct BBD)>1" }>} Distinct BBD ),$$Prinartsubnr ) )

[Anonymous · Accepted solution]

Hi Sasi,

You came really close to the right answer! I changed sum( to count( and that gave me the right result! Thanks a lot!!!!!!!!!

Right formula:

=count(Aggr(Count({<$$Prinartsubnr ={"=count(Distinct BBD)>1" }>} Distinct BBD ),$$Prinartsubnr ) )

Thanks again! Everyone thanks again for help! This got me really excited!