topic How to split an item? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369402#M137335 <HTML><HEAD></HEAD><BODY><P>load</P><P>Header1, Header2,</P><P>if(Header1 = 'a', 30,If(Header1='b', 21)) as Header3</P><P>from your table...</P></BODY></HTML> Mon, 26 Mar 2012 14:05:02 GMT jvitantonio 2012-03-26T14:05:02Z How to split an item? https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369401#M137334 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I have a database in QV that are considering the item a and b together. Example, a has 30 units and b has 21 units, but my data is as below:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH></TR><TR><TD>a</TD><TD>50</TD></TR><TR><TD>b</TD><TD>1</TD></TR><TR><TD>c</TD><TD>20</TD></TR><TR><TD>d</TD><TD>30</TD></TR></TBODY></TABLE><P><BR />How can I create a third header with a condition to consider item a only with 30 units and item b with only 21 units? Is it possible?</P><P></P><P>Tks and rgds,</P><P>Jorge.</P></BODY></HTML> Mon, 26 Mar 2012 13:59:13 GMT https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369401#M137334 2012-03-26T13:59:13Z How to split an item? https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369402#M137335 <HTML><HEAD></HEAD><BODY><P>load</P><P>Header1, Header2,</P><P>if(Header1 = 'a', 30,If(Header1='b', 21)) as Header3</P><P>from your table...</P></BODY></HTML> Mon, 26 Mar 2012 14:05:02 GMT https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369402#M137335 jvitantonio 2012-03-26T14:05:02Z How to split an item? https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369403#M137336 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; How you got the condition has a=30 and b=21?Is it always 30 and 21?Did you calculated based on some data?</P><P></P><P>Celambarasan</P></BODY></HTML> Mon, 26 Mar 2012 14:18:08 GMT https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369403#M137336 CELAMBARASAN 2012-03-26T14:18:08Z How to split an item? https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369404#M137337 <HTML><HEAD></HEAD><BODY><P> Actually, i forgot to mention, item a is based 60% for a and 40% for b + b units</P></BODY></HTML> Mon, 26 Mar 2012 14:29:33 GMT https://community.qlik.com/t5/QlikView/How-to-split-an-item/m-p/369404#M137337 2012-03-26T14:29:33Z