Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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