Qlik Sense Dimension on #KPI

[datashaw]

Dear Experts,

I would like to show QlikSense dimension on #KPI but the result gives me just '-' Hyphen. please hep me below logic  to show on KPI

=FirstSortedValue(ITEM_STATUS, -(STATUS_DATE+STATUS_TIME))

[JordyWegman]

Hi, 

Please check the help for this. FirstSortedValue is not a front-end function, but a script function.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/AggregationFun...

What you can do is make a Dual of your Item_Status (check Qlik Help) and do a Min or Max on that value.

Jordy

Climber