topic Re: How To change Row Value while creating Straight table in QlikView https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413395#M816177 <HTML><HEAD></HEAD><BODY><P>But not sure, How many field values you need to change?</P></BODY></HTML> Thu, 14 Sep 2017 06:23:42 GMT Anil_Babu_Samineni 2017-09-14T06:23:42Z How To change Row Value while creating Straight table https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413392#M816174 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>How I can replace</P><P></P><P>* as CurrentYear </P><P>? as PreviousYear</P><P># as PreviousYear</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenue</STRONG></TH></TR><TR><TD>*ACTUAL</TD><TD>2</TD></TR><TR><TD style="padding: 2px;">?ACTUAL</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">Revenue#</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P></P><P>Table Should be like this</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenue</STRONG></TH></TR><TR><TD style="padding: 2px;">2017ACTUAL</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">2016ACTUAL</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">REVENUE2016</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413392#M816174 sspawar88 2020-11-25T16:16:04Z Re: How To change Row Value while creating Straight table https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413393#M816175 <HTML><HEAD></HEAD><BODY><P>Hi Satish,</P><P>may be like (in Script)</P><P>LOAD Field,</P><P><SPAN style="color: #0000ff; font-size: 10pt;">Replace</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">Replace</SPAN>(<SPAN style="color: #0000ff;">Replace</SPAN>(Data,'*',<SPAN style="color: #0000ff;">Year</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>())),'?',<SPAN style="color: #0000ff;">Year</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>())-1),'#',<SPAN style="color: #0000ff;">Year</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN></SPAN><SPAN style="font-size: 10pt;">())-1)&nbsp; as Data</SPAN></P><P><SPAN style="font-size: 10pt;">From Table;</SPAN></P><P><SPAN style="font-size: 10pt;">Or You can use Expression directly in straight table.</SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Thu, 14 Sep 2017 06:21:10 GMT https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413393#M816175 antoniotiman 2017-09-14T06:21:10Z Re: How To change Row Value while creating Straight table https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413394#M816176 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>=Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176512_Capture.PNG" style="height: 147px; width: 620px;" /></P></BODY></HTML> Thu, 14 Sep 2017 06:23:15 GMT https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413394#M816176 Anil_Babu_Samineni 2017-09-14T06:23:15Z Re: How To change Row Value while creating Straight table https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413395#M816177 <HTML><HEAD></HEAD><BODY><P>But not sure, How many field values you need to change?</P></BODY></HTML> Thu, 14 Sep 2017 06:23:42 GMT https://community.qlik.com/t5/QlikView/How-To-change-Row-Value-while-creating-Straight-table/m-p/1413395#M816177 Anil_Babu_Samineni 2017-09-14T06:23:42Z