
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display one field as a KPI
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
normally it's the same as below, can you tell me what exactly is the problem
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how do we identify the '89 row ?fixe value ?
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you analyzing [KPI ID] then may be
Sum({<[KPI ID)={$(=Min([KPI ID]))}>} Value)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorr, I only want the value 89 to be displayed as a KPI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What are you getting when you use same expression in KPI? And also, Do you have any business logic for that

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous Replies
-
- 1
- 2
- Next Replies »