is there any alternate function for
I tried to use this function in qliksense . and throws an error saying invalid function.
Nope. It's a function that doesn't (yet) exist in Qlik Sense: QlikView functions and statements not supported in Qlik Sense ‒ Qlik Sense. There's no fully functional equivalent of Qlikview Groups in Qlik Sense.
Retrieving data ...