Display one field as a KPI

[Malbrecht]

I want to display just one field out of a table as a KPI. Since the table already constists of the finalized numbers and don't need any caculation, how can I display one field out of the row value as a KPI?

In this example it would be the row value and the field "89".

KPI ID	Name	Value	Reference	Process
1	w	89	87	A
2	x	0,2	0,18	A
3	y	5	6	B
4	z	184093	193439	B

Thanks for your help.

[Taoufiq_Zarra]

@Malbrecht 

how do we identify the '89 row ?fixe value ?

[Anil_Babu_Samineni]

If you analyzing [KPI ID] then may be

Sum({<[KPI ID)={$(=Min([KPI ID]))}>} Value)

[Malbrecht]

Sorr, I only want the value 89 to be displayed as a KPI.

[Anil_Babu_Samineni]

What are you getting when you use same expression in KPI? And also, Do you have any business logic for that

[Taoufiq_Zarra]

can you provide more detail,

"Sorr, I only want the value 89 to be displayed as a KPI." in this case I will put KPI= '89'

[Malbrecht]

To clarify: I want to have a KPI-Box. This KPI Box should contain the value 89 and the name x. 

My problem is if I use the KPI-Box, Qliksense asks me which measure and aggregation I want to use, but I don't want any aggregation, because the value 89 is the number I want to display. 

ID	Name	Value
1	x	89
2	y	0,2

In the end it should look like this:

Thanks for your help.

[Taoufiq_Zarra · Accepted solution]

as I understand it
you have the ID identified and you want to display the values for that ID, in this case

for x:

=Only({<ID={1}>} Name)

for 89 :

=Only({<ID={1}>} Value)

[Taoufiq_Zarra]

[Malbrecht]

Thank you very much, this was exactly what I wanted! Can you also tell me if I want to display 3 KPIs in a Multi KPI box and only want to see the ID 2, 3 and 4 from my table. It should look similar to this:

Thanks in advance.