topic Re: Help needed on Calculated Dimenssion.. in QlikView https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337982#M492034 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Sagar,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I'm lost here! I can't follow you completely. Please can you explain in detail? I understand that you wanted the last row but what do you mean by...</SPAN></P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Sagar Gupta wrote:</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Note: i have 20 different calculated metrices but here i have shown only two(A-B &amp; A/B), so don't ask me to write expressions for Quarters(Q8 to Q7 and Q5-Q1).</SPAN></P><P></P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Do you want to calculate in Script or Charts?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sat, 04 Aug 2012 16:04:18 GMT IAMDV 2012-08-04T16:04:18Z Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337981#M492033 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a dimenssion(Q8-Q1) which I want to modify as below:</P><P></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>Dimenssion</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A-B</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A/B</STRONG></SPAN></TH></TR><TR><TD>Q8</TD><TD>12</TD><TD>50%</TD></TR><TR><TD>Q7</TD><TD>24</TD><TD>29%</TD></TR><TR><TD>Q6</TD><TD>25</TD><TD>94%</TD></TR><TR><TD>Q5</TD><TD>7</TD><TD>52%</TD></TR><TR><TD>Q4</TD><TD>64</TD><TD>94%</TD></TR><TR><TD>Q3</TD><TD>44</TD><TD>12%</TD></TR><TR><TD>Q2</TD><TD>35</TD><TD>33%</TD></TR><TR><TD>Q1</TD><TD>43</TD><TD>73%</TD></TR><TR><TD><SPAN style="font-size: 12pt;"><STRONG><EM>Q5-Q1</EM></STRONG></SPAN></TD><TD><SPAN style="font-size: 12pt;"><STRONG><EM>-36</EM></STRONG></SPAN></TD><TD><SPAN style="font-size: 12pt;"><STRONG><EM>-21%</EM></STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>the last row showing difference of Q5 and Q1.</P><P></P><P>If anyone has any idea plzz let me know, any sort of help will be highly appreciated.</P><P></P><P>Note: i have 20 different calculated metrices but here i have shown only two(A-B &amp; A/B), so don't ask me to write expressions for Quarters(Q8 to Q7 and Q5-Q1).</P><P></P><P></P><P>Thanks</P><P>Sagar Gupta</P></BODY></HTML> Sat, 04 Aug 2012 13:48:50 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337981#M492033 2012-08-04T13:48:50Z Re: Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337982#M492034 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Sagar,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I'm lost here! I can't follow you completely. Please can you explain in detail? I understand that you wanted the last row but what do you mean by...</SPAN></P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Sagar Gupta wrote:</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Note: i have 20 different calculated metrices but here i have shown only two(A-B &amp; A/B), so don't ask me to write expressions for Quarters(Q8 to Q7 and Q5-Q1).</SPAN></P><P></P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Do you want to calculate in Script or Charts?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sat, 04 Aug 2012 16:04:18 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337982#M492034 IAMDV 2012-08-04T16:04:18Z Re: Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337983#M492035 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P></P><P>What i meant by the sentence you highlighted is:</P><P></P><P>I have fields as A and B, and what you can see here (A-B, A/B) are calculated metrices. So, like A-B and A/B there are 20 others.</P><P></P><P>Why I am telling you the above things is b'coz i dont want to write expressions 9 times(Q8, Q7....Q1, Q5-Q1) for each calculated metric(A-B).</P><P></P><P>Now If u r clear with my problem plz let me know the solution. I will be greatfull to you. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Sun, 05 Aug 2012 15:13:20 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337983#M492035 2012-08-05T15:13:20Z Re: Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337984#M492036 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks Sagar.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I don't think you are writing expression for each row rather you are writing expression based on Fields. So essentially you are writing expression only once. Please can you provide some sample data from your application? I'll mock up an example for you.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A href="http://QlikShare.com">www.QlikShare.com</A><BR /></SPAN></P></BODY></HTML> Sun, 05 Aug 2012 16:40:26 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337984#M492036 IAMDV 2012-08-05T16:40:26Z Re: Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337985#M492037 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P></P><P>If u r clear with my problem plzz do post a sample QV file. I will be greatfull to you.</P></BODY></HTML> Mon, 06 Aug 2012 09:45:34 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337985#M492037 2012-08-06T09:45:34Z Re: Help needed on Calculated Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337986#M492038 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P></P><P>Here is a sample file i created, plz plz help me dude.</P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Mon, 06 Aug 2012 11:54:29 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Calculated-Dimenssion/m-p/337986#M492038 2012-08-06T11:54:29Z