topic How to create a condition column in QV in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-condition-column-in-QV/m-p/377327#M140688 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I have a table as below:</P><P>I want to create this new column, considering the date in column C, with the condition that it shall consider only the date in column B as "Air" and also considering in column A for each number respectively.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="206" style="width: 412px; border: 1px solid rgb(0, 0, 0); height: 133px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>B</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>New Column</STRONG></SPAN></TH></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">01/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Ball</TD><TD style="text-align: center;">02/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Car</TD><TD style="text-align: center;">03/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Ball</TD><TD style="text-align: center;">20/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">21/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Car</TD><TD style="text-align: center;">22/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Desk</TD><TD style="text-align: center;">23/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Desk</TD><TD style="text-align: center;">01/02/2012</TD><TD style="text-align: center;">02/02/2012</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">02/02/2012</TD><TD style="text-align: center;">02/02/2012</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Regards, Jorge</P></BODY></HTML> Mon, 13 Aug 2012 13:52:35 GMT 2012-08-13T13:52:35Z How to create a condition column in QV https://community.qlik.com/t5/QlikView/How-to-create-a-condition-column-in-QV/m-p/377327#M140688 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I have a table as below:</P><P>I want to create this new column, considering the date in column C, with the condition that it shall consider only the date in column B as "Air" and also considering in column A for each number respectively.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="206" style="width: 412px; border: 1px solid rgb(0, 0, 0); height: 133px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>B</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>New Column</STRONG></SPAN></TH></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">01/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Ball</TD><TD style="text-align: center;">02/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Car</TD><TD style="text-align: center;">03/01/2012</TD><TD style="text-align: center;">01/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Ball</TD><TD style="text-align: center;">20/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">21/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Car</TD><TD style="text-align: center;">22/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Desk</TD><TD style="text-align: center;">23/01/2012</TD><TD style="text-align: center;">21/01/2012</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Desk</TD><TD style="text-align: center;">01/02/2012</TD><TD style="text-align: center;">02/02/2012</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Air</TD><TD style="text-align: center;">02/02/2012</TD><TD style="text-align: center;">02/02/2012</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Regards, Jorge</P></BODY></HTML> Mon, 13 Aug 2012 13:52:35 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-condition-column-in-QV/m-p/377327#M140688 2012-08-13T13:52:35Z Re: How to create a condition column in QV https://community.qlik.com/t5/QlikView/How-to-create-a-condition-column-in-QV/m-p/377328#M140689 <HTML><HEAD></HEAD><BODY><P>In a chart, you can try something like</P><P></P><P><EM>=only({&lt;B={Air}&gt;} total&lt;A&gt; C)</EM></P></BODY></HTML> Mon, 13 Aug 2012 13:56:53 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-condition-column-in-QV/m-p/377328#M140689 swuehl 2012-08-13T13:56:53Z