topic Re: Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382004#M799752 <HTML><HEAD></HEAD><BODY><P>Dear Jamel,</P><P></P><P>&nbsp;&nbsp; Below, some samples how to implement master calendar table:</P><P><A href="https://community.qlik.com/docs/DOC-3858">Master Calendar Generation Script</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/2802">The Master Calendar</A>‌</P><P><A href="https://community.qlik.com/thread/158524">Use of Master Calendar</A></P></BODY></HTML> Mon, 27 Nov 2017 18:51:47 GMT Ricardo_Gerhard 2017-11-27T18:51:47Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381995#M799743 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have two tables:</P><P></P><UL><LI>Sales</LI><LI>Returns</LI></UL><P></P><P>These two tables cannot be joined but I would like to write an expressions which is something like the sum of sales where sales customer matches the return customer number. </P><P></P><P>This would then allow me to have a sales value versus returns value within the same straight table.</P><P></P><P>Can this be done?</P><P></P><P>I hope this make sense?!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381995#M799743 Anonymous 2020-11-25T16:16:04Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381996#M799744 <HTML><HEAD></HEAD><BODY><P>Hi Jamel,</P><P></P><P>Just for a better understanding, why cant you join the 2 tables?</P></BODY></HTML> Mon, 27 Nov 2017 16:49:04 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381996#M799744 Anonymous 2017-11-27T16:49:04Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381997#M799745 <HTML><HEAD></HEAD><BODY><P>Join your sales and returns on your customer number this way the flow will be smooth when you use any chart objects. Any specific reason of not joining? </P></BODY></HTML> Mon, 27 Nov 2017 16:53:06 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381997#M799745 vishsaggi 2017-11-27T16:53:06Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381998#M799746 <HTML><HEAD></HEAD><BODY><P>I've got a master calendar, so when i try to do a join this cause loops.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 27 Nov 2017 16:54:08 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381998#M799746 Anonymous 2017-11-27T16:54:08Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381999#M799747 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You could share a sample of data.</P></BODY></HTML> Mon, 27 Nov 2017 16:58:55 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1381999#M799747 el_aprendiz111 2017-11-27T16:58:55Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382000#M799748 <HTML><HEAD></HEAD><BODY><P>Can you share a snapshot of your data model?</P></BODY></HTML> Mon, 27 Nov 2017 17:08:35 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382000#M799748 vishsaggi 2017-11-27T17:08:35Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382001#M799749 <HTML><HEAD></HEAD><BODY><P>Don't worry about this one guys.&nbsp; I will try and tackle it a different way.</P><P></P><P>I thought there was something which you can do in an expression but I am guessing there isn't.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 27 Nov 2017 17:13:55 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382001#M799749 Anonymous 2017-11-27T17:13:55Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382002#M799750 <HTML><HEAD></HEAD><BODY><P>We can try if you can share some sample data with an expected output? Without looking at the data it is kind of tough to give you any advice. </P></BODY></HTML> Mon, 27 Nov 2017 17:23:39 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382002#M799750 vishsaggi 2017-11-27T17:23:39Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382003#M799751 <HTML><HEAD></HEAD><BODY><P>This kind of situations most of the times can be solved concatenating fact tables (sales and returns).</P><P></P><P>A snapshot or some kind of guide about the model will be need to provide more accurate answer.</P></BODY></HTML> Mon, 27 Nov 2017 18:26:56 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382003#M799751 rubenmarin 2017-11-27T18:26:56Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382004#M799752 <HTML><HEAD></HEAD><BODY><P>Dear Jamel,</P><P></P><P>&nbsp;&nbsp; Below, some samples how to implement master calendar table:</P><P><A href="https://community.qlik.com/docs/DOC-3858">Master Calendar Generation Script</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/2802">The Master Calendar</A>‌</P><P><A href="https://community.qlik.com/thread/158524">Use of Master Calendar</A></P></BODY></HTML> Mon, 27 Nov 2017 18:51:47 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/1382004#M799752 Ricardo_Gerhard 2017-11-27T18:51:47Z