Qlik Community

App Development

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
datashaw
Contributor III
Contributor III

Qlik Sense Dimension on #KPI

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))

Labels (1)
1 Reply
JordyWegman
Partner
Partner

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

Work smarter, not harder