topic Re: calculated Dimension in QlikView

topic Re: calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371171#M138053 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:47:44 GMT 2012-07-27T08:47:44Z calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371165#M138047 <HTML><HEAD></HEAD><BODY><P>How should i write a calculated dimension if i have to display the dimension acc. to some condition? </P><P>EX:  content of table 'A' is: </P><P>  </P><P>   COL1            COL2                COL3</P><P>     A                    14                     18</P><P></P><P></P><P> table 'B' is:</P><P></P><P>  COL1             COL2                COL3</P><P></P><P></P><P>Now i want "COL2" as my dimension based on the condition that the data in COL3 is in between COL2 data and COL3 data.</P><P></P><P>Please help.</P></BODY></HTML> Fri, 27 Jul 2012 07:36:33 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371165#M138047 2012-07-27T07:36:33Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371166#M138048 <HTML><HEAD></HEAD><BODY><P>I'm unclear as to what you mean. Can you clarify the question a bit?</P></BODY></HTML> Fri, 27 Jul 2012 07:37:34 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371166#M138048 Anonymous 2012-07-27T07:37:34Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371167#M138049 <HTML><HEAD></HEAD><BODY><P>i want my dimension as col2 of yable B but on the graph, i just want to show only those values of COL2 which are in between some given values of col2 and col3 of table A.</P></BODY></HTML> Fri, 27 Jul 2012 08:08:11 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371167#M138049 2012-07-27T08:08:11Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371168#M138050 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:46:11 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371168#M138050 2012-07-27T08:46:11Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371169#M138051 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:46:22 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371169#M138051 2012-07-27T08:46:22Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371170#M138052 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:47:22 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371170#M138052 2012-07-27T08:47:22Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371171#M138053 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:47:44 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371171#M138053 2012-07-27T08:47:44Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371172#M138054 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 10pt;">please post ur problem with some data  or good scenario then only people will help you.</SPAN></P></BODY></HTML> Fri, 27 Jul 2012 08:48:24 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371172#M138054 2012-07-27T08:48:24Z Re: calculated Dimension https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371173#M138055 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">If i understood your question, the below code may helps you.</SPAN></P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    Col1, Col2, Col3</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    A, 14, 18</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    A, 15, 19</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">];</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Concatenate</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">LOAD *, Col2 as tempCol2;</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">LOAD * INLINE [</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    Col1, Col2, Col3</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    B, 16, 20</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    B, 17, 21</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">];</SPAN></P><P></P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">- Take dimension as =If(Col2<>tempCol2,Col2) & Expr as Count(Col2). Please check the enclosed file for your reference.</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;">Jagan<BR /></SPAN></P></BODY></HTML> Fri, 27 Jul 2012 09:49:34 GMT https://community.qlik.com/t5/QlikView/calculated-Dimension/m-p/371173#M138055 jagannalla 2012-07-27T09:49:34Z