Qlik Community

Qlik Sense App Development

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

datashaw
New 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