topic Re: calculation!! in QlikView https://community.qlik.com/t5/QlikView/calculation/m-p/633965#M232518 <HTML><HEAD></HEAD><BODY><P>What is CAT1 and CAT2 in this example?</P></BODY></HTML> Thu, 15 May 2014 06:59:10 GMT Anonymous 2014-05-15T06:59:10Z calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633958#M232511 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need to&nbsp; calculate&nbsp;&nbsp; <STRONG>CAL</STRONG> column some values based on <STRONG>cat:</STRONG></P><P></P><TABLE border="1" class="jiveBorder" height="94" style="border: 1px solid rgb(0, 0, 0); width: 450px; height: 13px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Res Id </TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">101</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>102</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>103</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>104</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>105</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>cat</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">cal</TH></TR><TR><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">SV</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">Tw</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>=(8*weight )+(102*weight)+(103*weight)+(104*weight)+(105*weight)multiply by 10 how i can write a expression here </P></BODY></HTML> Thu, 15 May 2014 05:38:12 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633958#M232511 2014-05-15T05:38:12Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633959#M232512 <HTML><HEAD></HEAD><BODY><P>Sry gus i did a mistake </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=(value of 101*weight )+(v<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">alue of 10</SPAN>2*weight)+(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">value of </SPAN>103*weight)+(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">value of </SPAN>104*weight)+(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">value of </SPAN>105*weight)multiply by 10 how i can write a expression here</SPAN></P></BODY></HTML> Thu, 15 May 2014 05:42:52 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633959#M232512 2014-05-15T05:42:52Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633960#M232513 <HTML><HEAD></HEAD><BODY><P>Elaborate more please..</P></BODY></HTML> Thu, 15 May 2014 05:43:39 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633960#M232513 its_anandrjs 2014-05-15T05:43:39Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633961#M232514 <HTML><HEAD></HEAD><BODY><P>101,102....105 are columns or field values.</P></BODY></HTML> Thu, 15 May 2014 05:48:12 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633961#M232514 its_anandrjs 2014-05-15T05:48:12Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633962#M232515 <HTML><HEAD></HEAD><BODY><P>8*weight or 8* 101?</P></BODY></HTML> Thu, 15 May 2014 06:13:09 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633962#M232515 MK_QSL 2014-05-15T06:13:09Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633963#M232516 <HTML><HEAD></HEAD><BODY><P>Hi Suneel,</P><P></P><P>PFA for your expression.</P><P></P><P>Cheers!</P><P>Laxmi</P></BODY></HTML> Thu, 15 May 2014 06:21:39 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633963#M232516 Anonymous 2014-05-15T06:21:39Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633964#M232517 <HTML><HEAD></HEAD><BODY><P>Thank u so much but </P><P></P><P>Here <STRONG>Cat1 has some weight valu</STRONG>e and <STRONG>Cat2 has some weight value&nbsp; how we can do </STRONG></P><P></P><P>What is the if condtion</P></BODY></HTML> Thu, 15 May 2014 06:51:03 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633964#M232517 2014-05-15T06:51:03Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633965#M232518 <HTML><HEAD></HEAD><BODY><P>What is CAT1 and CAT2 in this example?</P></BODY></HTML> Thu, 15 May 2014 06:59:10 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633965#M232518 Anonymous 2014-05-15T06:59:10Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633966#M232519 <HTML><HEAD></HEAD><BODY><P>Category 1&nbsp; and Category 2 </P><P></P><P>here Category 1 = Sv and Category 2 =TW</P><P></P><P>Sv has own weight value and Tw has Own own weight value </P><P></P><P></P><P>in&nbsp; your example only one weight value is there right </P></BODY></HTML> Thu, 15 May 2014 07:02:35 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633966#M232519 2014-05-15T07:02:35Z Re: Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633967#M232520 <HTML><HEAD></HEAD><BODY><P>You can create another expression called "Weight" and change its values based on your condition.</P><P></P><P>I have attatched the updated .qvw file.</P><P>Hope it helps you.</P><P></P><P>Cheers!</P><P>Laxmi</P></BODY></HTML> Thu, 15 May 2014 07:11:08 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633967#M232520 Anonymous 2014-05-15T07:11:08Z Re: calculation!! https://community.qlik.com/t5/QlikView/calculation/m-p/633968#M232521 <HTML><HEAD></HEAD><BODY><P>thank u for u support </P><P></P><P></P><P>Done same thing in application but Doesn't show the any values in my straight table&nbsp; </P><P></P><P>i do any thing wrong !</P><P></P><P>send me u r email id if u interested i will send u application </P></BODY></HTML> Thu, 15 May 2014 07:47:47 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/633968#M232521 2014-05-15T07:47:47Z