Qlik Sense Dimension on #KPI

datashaw — Sat, 16 Nov 2024 05:37:29 GMT

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

Re: Qlik Sense Dimension on #KPI

JordyWegman — Tue, 11 Jun 2019 14:36:56 GMT

Hi,

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

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