Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryChin
Contributor III
Contributor III

How to show the latest data in KPI

Hi All,

I want to show the 3 parameter in 3 single KPI

The data show below

Data2.PNG

In the KPI expression I typed

FirstSortedValue(distinct measure_value,-measure_time)

The KPI shown 

KPI.PNG

The measure_time of temp, CO2 and HR are same. If I don't type 'distinct' in the expression it will show nothing 

KPI2.PNG

How to show the other 2 parameter CO2 & HR in KPI?

 

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

FirstSortedValue({<measure_value={'CO2'}>}measure_value,-measure_time)

 

View solution in original post

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

FirstSortedValue({<measure_value={'CO2'}>}measure_value,-measure_time)