topic Re: Format/Reduce a Number in QlikView https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445180#M818919 <HTML><HEAD></HEAD><BODY><P>May be do this?</P><P><STRONG>Left(PersonID, 6) as PersonID_Copy</STRONG></P></BODY></HTML> Tue, 22 Aug 2017 13:10:56 GMT Anil_Babu_Samineni 2017-08-22T13:10:56Z Format/Reduce a Number https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445178#M818917 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I wonder how i can format/reduce a "number" in load script.</P><P></P><P></P><P>PersonalID Has the format for example 7788991010 i would like in the script to reduce it to 778899</P><P></P><P>ive tries like</P><P></P><P>num(PersonIID, 'XXXXXX' ) as PID,</P><P></P><P>but it doesent work.</P><P></P><P>since my sollution didnt work, i would like to know how to reduce a values numbers within script. </P><P></P><P>Could anyone plz enlight me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thx in advance. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445178#M818917 harjedalskok 2020-11-25T16:16:04Z Re: Format/Reduce a Number https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445179#M818918 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Floor(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PersonIID</SPAN>/10000) as PID</STRONG></P><P></P><P>or this</P><P></P><P><STRONG>Left(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>PersonIID, 6) as PID</STRONG></SPAN></P></BODY></HTML> Tue, 22 Aug 2017 13:10:43 GMT https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445179#M818918 sunny_talwar 2017-08-22T13:10:43Z Re: Format/Reduce a Number https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445180#M818919 <HTML><HEAD></HEAD><BODY><P>May be do this?</P><P><STRONG>Left(PersonID, 6) as PersonID_Copy</STRONG></P></BODY></HTML> Tue, 22 Aug 2017 13:10:56 GMT https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445180#M818919 Anil_Babu_Samineni 2017-08-22T13:10:56Z Re: Format/Reduce a Number https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445181#M818920 <HTML><HEAD></HEAD><BODY><P>Thx for fast reply.</P><P></P><P>This is now solved. I couldnt mark both answers as "solution". </P></BODY></HTML> Tue, 22 Aug 2017 13:18:56 GMT https://community.qlik.com/t5/QlikView/Format-Reduce-a-Number/m-p/1445181#M818920 harjedalskok 2017-08-22T13:18:56Z