topic Re: Help needed on Dimenssion.. in QlikView https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363933#M135375 <HTML><HEAD></HEAD><BODY><P>Hi Perumal,</P><P></P><P>I guess you miss understood my problem.</P><P></P><P>I wanted my feids to display the related values</P><P></P><P>For eg: Q8( A=24)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q7(A=18)</P><P></P><P>&nbsp;&nbsp;&nbsp; Then my Q8-Q7 should give(6)</P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Tue, 24 Jul 2012 06:00:27 GMT 2012-07-24T06:00:27Z Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363929#M135371 <HTML><HEAD></HEAD><BODY><DIV><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>Quarter</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>B</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C</STRONG></SPAN></TH></TR><TR><TD>Q8</TD><TD>95</TD><TD>58</TD><TD>334</TD></TR><TR><TD>Q7</TD><TD>75</TD><TD>56</TD><TD>47</TD></TR><TR><TD>Q6</TD><TD>4556</TD><TD>87</TD><TD>87</TD></TR><TR><TD>Q5</TD><TD>78</TD><TD>3466</TD><TD>987</TD></TR><TR><TD>Q4</TD><TD>4568</TD><TD>65</TD><TD>5</TD></TR><TR><TD>Q3</TD><TD>8</TD><TD>4</TD><TD>231</TD></TR><TR><TD>Q2</TD><TD>567</TD><TD>587</TD><TD>65</TD></TR><TR><TD>Q1</TD><TD>9</TD><TD>353</TD><TD>78</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>I have my table as above and i want it to display the data as below:</DIV><DIV> </DIV><DIV> </DIV><DIV><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>Quarter</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>B</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C</STRONG></SPAN></TH></TR><TR><TD><STRONG>Q8-Q7</STRONG></TD><TD>95</TD><TD>58</TD><TD>334</TD></TR><TR><TD><STRONG>Q7-Q6</STRONG></TD><TD>75</TD><TD>56</TD><TD>47</TD></TR><TR><TD><STRONG>Q6-Q5</STRONG></TD><TD>4556</TD><TD>87</TD><TD>87</TD></TR><TR><TD><STRONG>Q5-Q4</STRONG></TD><TD>78</TD><TD>3466</TD><TD>987</TD></TR><TR><TD><STRONG>Q4-Q3</STRONG></TD><TD>4568</TD><TD>65</TD><TD>5</TD></TR><TR><TD><STRONG>Q3-Q2</STRONG></TD><TD>8</TD><TD>4</TD><TD>231</TD></TR><TR><TD><STRONG>Q2-Q1</STRONG></TD><TD>567</TD><TD>587</TD><TD>65</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Tue, 24 Jul 2012 04:56:27 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363929#M135371 2012-07-24T04:56:27Z Re: Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363930#M135372 <HTML><HEAD></HEAD><BODY><P>Hi Sagar</P><P></P><P>use this Expression</P><P></P><P>=fieldname&amp;'-'&amp;num(replace(fieldname,'Q',''))-1.</P><P>this useful for u </P><P></P><P>Regards</P><P>Perumal</P></BODY></HTML> Tue, 24 Jul 2012 05:03:06 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363930#M135372 perumal_41 2012-07-24T05:03:06Z Re: Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363931#M135373 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Do u mean this:&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style=": ; font-size: 1;"></SPAN></SPAN></P><P>=</P><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;"> &amp;'-'&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">replace</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;">,'Q',''))-1. </SPAN><P></P></BODY></HTML> Tue, 24 Jul 2012 05:39:06 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363931#M135373 2012-07-24T05:39:06Z Re: Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363932#M135374 <HTML><HEAD></HEAD><BODY><P>Hi sagar </P><P></P><P>sorry .some missed in Expression now use this expression </P><P><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;"> &amp;'-'&amp;'Q'&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">replace</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;">,'Q',''))-1. </SPAN></P></BODY></HTML> Tue, 24 Jul 2012 05:44:26 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363932#M135374 perumal_41 2012-07-24T05:44:26Z Re: Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363933#M135375 <HTML><HEAD></HEAD><BODY><P>Hi Perumal,</P><P></P><P>I guess you miss understood my problem.</P><P></P><P>I wanted my feids to display the related values</P><P></P><P>For eg: Q8( A=24)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q7(A=18)</P><P></P><P>&nbsp;&nbsp;&nbsp; Then my Q8-Q7 should give(6)</P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Tue, 24 Jul 2012 06:00:27 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363933#M135375 2012-07-24T06:00:27Z Re: Help needed on Dimenssion.. https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363934#M135376 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>in Expression side use this expression </P><P></P><P>=Sum(Value)-below(Sum(Value)</P><P></P><P>.Try thsi expression</P><P>Regards</P><P>Perumal A</P></BODY></HTML> Tue, 24 Jul 2012 06:09:18 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Dimenssion/m-p/363934#M135376 perumal_41 2012-07-24T06:09:18Z