https://community.qlik.com/t5/App-Development/Need-to-get-only-Levels-from-userid/m-p/1820801#M67287 <P>Hello Harish,</P><P>Something like this should help you return LevelType, assuming the delimiter is always '-'.</P><P>=mid([<SPAN>UserID</SPAN>],index([<SPAN>UserID</SPAN>],'-',1),len([<SPAN>UserID</SPAN>]) - len(index([<SPAN>UserID</SPAN>],'-',1)))</P><P>&nbsp;</P> Thu, 08 Jul 2021 16:52:33 GMT lowrycody 2021-07-08T16:52:33Z https://community.qlik.com/t5/App-Development/Need-to-get-only-Levels-from-userid/m-p/1820793#M67285 <P>Hi All,</P><P>I want to get the User Level from the UserField.This Field has the Userid along with LevelType.</P><P>UserID</P><P>ABCL1&nbsp; &nbsp; -L1</P><P>HZHL2 -L2</P><P>HSDL3-L3</P><P>JHHJ-NA</P><P>GHJD-NA</P><P>GHJJ-NA</P> Thu, 08 Jul 2021 15:11:33 GMT https://community.qlik.com/t5/App-Development/Need-to-get-only-Levels-from-userid/m-p/1820793#M67285 MEDHA07 2021-07-08T15:11:33Z https://community.qlik.com/t5/App-Development/Need-to-get-only-Levels-from-userid/m-p/1820801#M67287 <P>Hello Harish,</P><P>Something like this should help you return LevelType, assuming the delimiter is always '-'.</P><P>=mid([<SPAN>UserID</SPAN>],index([<SPAN>UserID</SPAN>],'-',1),len([<SPAN>UserID</SPAN>]) - len(index([<SPAN>UserID</SPAN>],'-',1)))</P><P>&nbsp;</P> Thu, 08 Jul 2021 16:52:33 GMT https://community.qlik.com/t5/App-Development/Need-to-get-only-Levels-from-userid/m-p/1820801#M67287 lowrycody 2021-07-08T16:52:33Z