Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Qlik Sense Dimension on #KPI

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