topic Re: How to create another Column in script in QlikView

topic Re: How to create another Column in script in QlikView https://community.qlik.com/t5/QlikView/How-to-create-another-Column-in-script/m-p/994605#M644479 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>LOAD TYPE,</STRONG></P><P><STRONG>          DATE_01,</STRONG></P><P><STRONG>          DATE_02,</STRONG></P><P><STRONG>          If(TYPE = 'A', DATE_01, DATE_02) as DATE_03</STRONG></P><P><STRONG>FROM source;</STRONG></P></BODY></HTML> Thu, 26 Nov 2015 22:00:50 GMT sunny_talwar 2015-11-26T22:00:50Z How to create another Column in script https://community.qlik.com/t5/QlikView/How-to-create-another-Column-in-script/m-p/994604#M644478 <HTML><HEAD></HEAD><BODY><P>I have this table,</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="205"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #4f81bd;" width="53">TYPE</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #4f81bd;" width="76">DATE_01</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #4f81bd;" width="76">DATE_02</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR></TBODY></TABLE><P></P><P>and i want to create a new column DATE_03 when if ([TYPE]="A";[DATE_01];[DATE_02])</P><P></P><P>This would result table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="281"><TBODY><TR><TD height="20" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #4f81bd;" width="53">TYPE</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #4f81bd;" width="76">DATE_01</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #4f81bd;" width="76">DATE_02</TD><TD class="xl65" style="font-size: 11pt; color: white; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #4f81bd;" width="76">DATE_03</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD><TD class="xl66" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD><TD class="xl66" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD><TD class="xl66" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background: #dce6f1;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type B</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;">Type A</TD></TR><TR><TD height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">A</TD><TD class="xl65" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD><TD style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type B</TD><TD class="xl66" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Type A</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 26 Nov 2015 20:57:47 GMT https://community.qlik.com/t5/QlikView/How-to-create-another-Column-in-script/m-p/994604#M644478 2015-11-26T20:57:47Z Re: How to create another Column in script https://community.qlik.com/t5/QlikView/How-to-create-another-Column-in-script/m-p/994605#M644479 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>LOAD TYPE,</STRONG></P><P><STRONG>          DATE_01,</STRONG></P><P><STRONG>          DATE_02,</STRONG></P><P><STRONG>          If(TYPE = 'A', DATE_01, DATE_02) as DATE_03</STRONG></P><P><STRONG>FROM source;</STRONG></P></BODY></HTML> Thu, 26 Nov 2015 22:00:50 GMT https://community.qlik.com/t5/QlikView/How-to-create-another-Column-in-script/m-p/994605#M644479 sunny_talwar 2015-11-26T22:00:50Z