topic Formula on Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Formula-on-Pivot-Table/m-p/178486#M45665 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a table with a lot of prices and variables.</P><P>I'm trying to do a calculated dimension with if clauses, but i have to concatenate all and it's so complicaded.</P><P>Can explain me someone if it's possible to do the next sentence:</P><P>Example</P><P>=if(A=1,1,0) + if(B=1,1,0) .......</P><P></P><P>There are a lot of combinations to do an if(A=1,if(b=1,if(c=.......), and I'm trying to do operations with separated if on the same formula.</P><P></P><P>Best regards,</P><P></P><P></P><P></P></BODY></HTML> Fri, 12 Mar 2010 15:10:20 GMT 2010-03-12T15:10:20Z Formula on Pivot Table https://community.qlik.com/t5/QlikView/Formula-on-Pivot-Table/m-p/178486#M45665 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a table with a lot of prices and variables.</P><P>I'm trying to do a calculated dimension with if clauses, but i have to concatenate all and it's so complicaded.</P><P>Can explain me someone if it's possible to do the next sentence:</P><P>Example</P><P>=if(A=1,1,0) + if(B=1,1,0) .......</P><P></P><P>There are a lot of combinations to do an if(A=1,if(b=1,if(c=.......), and I'm trying to do operations with separated if on the same formula.</P><P></P><P>Best regards,</P><P></P><P></P><P></P></BODY></HTML> Fri, 12 Mar 2010 15:10:20 GMT https://community.qlik.com/t5/QlikView/Formula-on-Pivot-Table/m-p/178486#M45665 2010-03-12T15:10:20Z Formula on Pivot Table https://community.qlik.com/t5/QlikView/Formula-on-Pivot-Table/m-p/178487#M45666 <HTML><HEAD></HEAD><BODY><P>It works,</P><P></P></BODY></HTML> Fri, 12 Mar 2010 15:14:35 GMT https://community.qlik.com/t5/QlikView/Formula-on-Pivot-Table/m-p/178487#M45666 2010-03-12T15:14:35Z