topic Re: replace number in field with new value in QlikView https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506928#M189537 <HTML><HEAD></HEAD><BODY><P>In the script, Just create the temp table that holds maximum value.</P><P></P><P>Temp:</P><P>LOAD Max([Posting Period]) as MaxPP Resident TableName;</P><P></P><P>Let vMaxPP = Peek('MaxPP') ;</P><P></P><P>LOAD *, $(vMaxPP) as [New Posting Period] resident TableName;</P><P></P><P>If you need to create the maximum for each month, create mapping table with Year and Max Posting Period and then replace existing field by using ApplyMap function</P></BODY></HTML> Mon, 11 Nov 2013 14:18:41 GMT 2013-11-11T14:18:41Z replace number in field with new value https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506927#M189536 <HTML><HEAD></HEAD><BODY><P>hi i have a field whereby i would like to replace the number with another number, this number should always be the maximum posting period ie. 11 for the current year. </P><P></P><P>As you see in the example i have the period 10 and 1, is it possible to replace these values with 11?</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48838_pastedImage_1.png" style="width: auto; height: auto;" /></P><P>Best</P><P>Brad</P></BODY></HTML> Mon, 11 Nov 2013 14:09:42 GMT https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506927#M189536 2013-11-11T14:09:42Z Re: replace number in field with new value https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506928#M189537 <HTML><HEAD></HEAD><BODY><P>In the script, Just create the temp table that holds maximum value.</P><P></P><P>Temp:</P><P>LOAD Max([Posting Period]) as MaxPP Resident TableName;</P><P></P><P>Let vMaxPP = Peek('MaxPP') ;</P><P></P><P>LOAD *, $(vMaxPP) as [New Posting Period] resident TableName;</P><P></P><P>If you need to create the maximum for each month, create mapping table with Year and Max Posting Period and then replace existing field by using ApplyMap function</P></BODY></HTML> Mon, 11 Nov 2013 14:18:41 GMT https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506928#M189537 2013-11-11T14:18:41Z Re: replace number in field with new value https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506929#M189538 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thank you in the case of resident name do you mean the table that holds my resident values?</P></BODY></HTML> Mon, 11 Nov 2013 14:25:22 GMT https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506929#M189538 2013-11-11T14:25:22Z Re: replace number in field with new value https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506930#M189539 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Mon, 11 Nov 2013 16:43:51 GMT https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506930#M189539 2013-11-11T16:43:51Z Re: replace number in field with new value https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506931#M189540 <HTML><HEAD></HEAD><BODY><P>You can also use expression</P><P>max({1} [Posting Period])</P></BODY></HTML> Mon, 11 Nov 2013 16:57:37 GMT https://community.qlik.com/t5/QlikView/replace-number-in-field-with-new-value/m-p/506931#M189540 Anonymous 2013-11-11T16:57:37Z