topic Re: RE: In And Out in QlikView https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984813#M336026 <HTML><HEAD></HEAD><BODY><P>Looking into this now</P></BODY></HTML> Wed, 09 Dec 2015 18:30:34 GMT sunny_talwar 2015-12-09T18:30:34Z RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984811#M336024 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P></P><P>i need the&nbsp; bar chart</P><P></P><P>incount in %&nbsp;&nbsp; is: no of people walkin into</P><P></P><P>outcount % :no .of people walked out</P><P></P><P>i hve tried with the expresion but i didnt get</P><P></P><P>exp output:&nbsp; the image i hve attached&nbsp; with the vallues&nbsp;&nbsp; in %..</P><P></P><P>thanks in advance</P><P></P><P>suresh</P></BODY></HTML> Wed, 09 Dec 2015 17:46:11 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984811#M336024 Chanty4u 2015-12-09T17:46:11Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984812#M336025 <HTML><HEAD></HEAD><BODY><P>hi sunny</P><P><A _jive_internal="true" data-avatarid="10792" data-externalid="" data-online="false" data-presence="null" data-userid="171708" data-username="sunindia" href="https://community.qlik.com/people/sunindia">Sunny T</A></P><P>can u look into this once.. </P></BODY></HTML> Wed, 09 Dec 2015 18:26:30 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984812#M336025 Chanty4u 2015-12-09T18:26:30Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984813#M336026 <HTML><HEAD></HEAD><BODY><P>Looking into this now</P></BODY></HTML> Wed, 09 Dec 2015 18:30:34 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984813#M336026 sunny_talwar 2015-12-09T18:30:34Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984814#M336027 <HTML><HEAD></HEAD><BODY><P>Hmm the issue is the expression that shwng the values in wrng format... i need in % format..</P></BODY></HTML> Wed, 09 Dec 2015 18:33:22 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984814#M336027 Chanty4u 2015-12-09T18:33:22Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984815#M336028 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>i hve tried with the expresion but i didnt get</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>What have you already tried? Can't see anything in the attached qvw brother</P></BODY></HTML> Wed, 09 Dec 2015 18:34:08 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984815#M336028 sunny_talwar 2015-12-09T18:34:08Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984816#M336029 <HTML><HEAD></HEAD><BODY><P>just i need the&nbsp; incount and outcount ....am nt getting the expressions for that and the chart which i hve in image exactly i want...</P></BODY></HTML> Wed, 09 Dec 2015 18:35:44 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984816#M336029 Chanty4u 2015-12-09T18:35:44Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984817#M336030 <HTML><HEAD></HEAD><BODY><P>hi sunny,</P><P></P><P>updated</P></BODY></HTML> Wed, 09 Dec 2015 18:37:57 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984817#M336030 Chanty4u 2015-12-09T18:37:57Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984818#M336031 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108513_Capture.PNG" style="max-width: 620px; height: auto;" /></P><P></P><P>Expression1: <SPAN style="font-size: 10pt; line-height: 1.5em;">Sum(Incount)/Sum(TOTAL Incount)</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">Expression2: <STRONG>Sum(Outcount)/Sum(TOTAL Outcount)</STRONG></SPAN></P></BODY></HTML> Wed, 09 Dec 2015 18:43:58 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984818#M336031 sunny_talwar 2015-12-09T18:43:58Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984819#M336032 <HTML><HEAD></HEAD><BODY><P>in combo chart also... the second expression is nt shwng exactly...what is the issue?</P></BODY></HTML> Wed, 09 Dec 2015 18:48:35 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984819#M336032 Chanty4u 2015-12-09T18:48:35Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984820#M336033 <HTML><HEAD></HEAD><BODY><P>Your cycle groups (dimension) uses year, Month, Date which are all from a non-linked table. So there is a implicit Cartesian product in your database which is why you see the sum(Total_sales) for both the years. Same is true for the second expression.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108524_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Dec 2015 18:52:42 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984820#M336033 sunny_talwar 2015-12-09T18:52:42Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984821#M336034 <HTML><HEAD></HEAD><BODY><P>yes sunny...but i attached one image... with in that i need to show the sales on year month date,,</P></BODY></HTML> Wed, 09 Dec 2015 18:54:53 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984821#M336034 Chanty4u 2015-12-09T18:54:53Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984822#M336035 <HTML><HEAD></HEAD><BODY><P>Is there a connection between ReceivedDate and Thedate or ReceivedDate and DateTime field? If you can join them on one of the two dates, you will see a better result.</P></BODY></HTML> Wed, 09 Dec 2015 18:56:50 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984822#M336035 sunny_talwar 2015-12-09T18:56:50Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984823#M336036 <HTML><HEAD></HEAD><BODY><P>thanks sunny for ur help......i will check tommorw and let u know</P></BODY></HTML> Wed, 09 Dec 2015 19:01:53 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984823#M336036 Chanty4u 2015-12-09T19:01:53Z Re: RE: In And Out https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984824#M336037 <HTML><HEAD></HEAD><BODY><P>great sunny............</P></BODY></HTML> Thu, 10 Dec 2015 12:50:46 GMT https://community.qlik.com/t5/QlikView/RE-In-And-Out/m-p/984824#M336037 Chanty4u 2015-12-10T12:50:46Z