Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

polmasanas
New Contributor

How can I get the latest KPI for a certain indicator?

Hey all!

I have been trying to get the KPI for a precise indicator. My table looks (similar) to this:

DatetimeIndicatorValueDate

201802010000

I19801/02/2018
201712310000I21231/12/2017
201712310000I33531/12/2017
201712190000I19419/12/2017
201711090000I110409/11/2017
201709010000I33301/09/2017
20170126I23026/01/2017

What i want to get is three different KPIs showing the most recent value (higher datetime) for the indicators, such as

          I1: 98

          I2: 12

          I3: 35

I have tried doing something like Sum( if( Datetime = Max(Datetime), if( Indicator = "I1", Value)))

Any help is much appreciated

Thank you!