topic Re: calculations !!!! in QlikView https://community.qlik.com/t5/QlikView/calculations/m-p/632149#M231953 <HTML><HEAD></HEAD><BODY><P>what is the formula for your index?</P></BODY></HTML> Wed, 14 May 2014 05:46:54 GMT 2014-05-14T05:46:54Z calculations !!!! https://community.qlik.com/t5/QlikView/calculations/m-p/632148#M231952 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a <STRONG>category</STRONG> in that i have 2 types like <STRONG>cat1</STRONG> and <STRONG>cat2</STRONG></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; each <STRONG>category</STRONG> have there <STRONG>respondID</STRONG></P><P></P><P>&nbsp;&nbsp;&nbsp; Now i want to calculate Index for each category i have a weights also </P><P></P><P>&nbsp; </P><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 428px; height: 77px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">category</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Satisfaction</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Loy</STRONG></TH></TR><TR><TD style="padding: 2px;">Cat1</TD><TD style="padding: 2px;">0.234</TD><TD style="padding: 2px;">0.567</TD></TR><TR><TD style="padding: 2px;">cat2</TD><TD style="padding: 2px;">0345</TD><TD style="padding: 2px;">0.789</TD></TR></TBODY></TABLE><P></P><P>suppose respond id is 100&nbsp; is under Cat1 now i want to calculate index value </P><P></P><P>how we can do that pls help me i f u need any info let me know</P></BODY></HTML> Wed, 14 May 2014 05:39:56 GMT https://community.qlik.com/t5/QlikView/calculations/m-p/632148#M231952 2014-05-14T05:39:56Z Re: calculations !!!! https://community.qlik.com/t5/QlikView/calculations/m-p/632149#M231953 <HTML><HEAD></HEAD><BODY><P>what is the formula for your index?</P></BODY></HTML> Wed, 14 May 2014 05:46:54 GMT https://community.qlik.com/t5/QlikView/calculations/m-p/632149#M231953 2014-05-14T05:46:54Z Re: calculations !!!! https://community.qlik.com/t5/QlikView/calculations/m-p/632150#M231954 <HTML><HEAD></HEAD><BODY><P>Can you also post data with your respondid?</P></BODY></HTML> Wed, 14 May 2014 05:47:12 GMT https://community.qlik.com/t5/QlikView/calculations/m-p/632150#M231954 2014-05-14T05:47:12Z Re: calculations !!!! https://community.qlik.com/t5/QlikView/calculations/m-p/632151#M231955 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Times New Roman','serif';">{(Rating given on S * Weight for S) + (Rating given on L * Weight for L)}<SPAN style="font-size: 11.0pt; font-family: 'Times New Roman','serif';">multiplied by 10</SPAN></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Times New Roman','serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Times New Roman','serif';">This is the formula<BR /></SPAN></P></BODY></HTML> Wed, 14 May 2014 05:51:00 GMT https://community.qlik.com/t5/QlikView/calculations/m-p/632151#M231955 2014-05-14T05:51:00Z