topic how to get output using multiples fact tables in QlikView https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288421#M107256 <HTML><HEAD></HEAD><BODY><P> Thanks in advanace sir , and shown interest to resolve issue</P></BODY></HTML> Tue, 23 Aug 2011 06:28:41 GMT vikasmahajan 2011-08-23T06:28:41Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288415#M107250 <HTML><HEAD></HEAD><BODY><P>Attaching here all tables output required like following</P><P></P><P>sales group - spade</P><P></P><P>Month - June</P><P></P><P>hq name&nbsp;&nbsp;&nbsp;&nbsp; abm name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbm name</P><P></P><P>Mesana</P><P></P><P>------------------------------------ Current Month -----------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -------------------------------------------&nbsp;&nbsp; ytd ------------------------------------------------</P><P></P><P>product name&nbsp;&nbsp;&nbsp; annual tar (tar_qty)&nbsp;&nbsp;&nbsp; targets(12000*monper.per)&nbsp; tys(net units from tys)&nbsp;&nbsp;&nbsp;&nbsp; targets(ytd)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ach(ytd)&nbsp; lys(ytd</P><P></P><P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P></P><P>abc&nbsp;&nbsp;&nbsp; -------- 12000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1080&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 504&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April to june)2640&nbsp;&nbsp;&nbsp; 1577&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1008&nbsp;&nbsp;&nbsp; </P><P></P><P>Please help me to get this output</P></BODY></HTML> Sun, 21 Aug 2011 10:43:20 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288415#M107250 vikasmahajan 2011-08-21T10:43:20Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288416#M107251 <HTML><HEAD></HEAD><BODY><P>Hi vikasmahajan,</P><P>from which fact tables? this is quite confusing for me. Can you please show the fact tables and then gives a clear idee of the tables output that you want get (with columns names, etc...).</P><P>Regards.</P></BODY></HTML> Sun, 21 Aug 2011 11:16:28 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288416#M107251 2011-08-21T11:16:28Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288417#M107252 <HTML><HEAD></HEAD><BODY><P>Ok, please do so on the advanced <STRONG>Edit</STRONG> option. </P></BODY></HTML> Sun, 21 Aug 2011 12:26:35 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288417#M107252 2011-08-21T12:26:35Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288418#M107253 <HTML><HEAD></HEAD><BODY><P>Dear Sir,</P><P></P><P>I have attached my all excels sheets&nbsp; in that i want to display output </P><P></P><P>MONTH - JUNE</P><P></P><P>HQ NAME&nbsp;&nbsp; RM NAME&nbsp;&nbsp; DM NAME</P><P></P><P></P><P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;---------- Current Month --------------- -------------------&gt;</P><P> PRODUCT&nbsp; ANNUAL TAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Target (month ie june)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ach Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lys Ach Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (BELOW YTD)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Target Qty from target.xls) ( tar_qty*monper.per/100)&nbsp; (net_qty from&nbsp; (net Qty</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tys for june)&nbsp;&nbsp;&nbsp; from Lys.xls for june10)</P><P></P><P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P></P><P></P><P>Same columns required in ytd in c</P><P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;---------- Current Month --------------- -------------------&gt;</P><P> PRODUCT&nbsp; ANNUAL TAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Target (month ie june)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ach Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lys Ach Qty&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Target Qty from target.xls) ( tar_qty*monper.per/100)&nbsp; (net_qty from&nbsp; (net Qty</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tys for june)&nbsp;&nbsp;&nbsp; from Lys.xls for june10)</P><P></P><P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</P></BODY></HTML> Mon, 22 Aug 2011 05:17:19 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288418#M107253 vikasmahajan 2011-08-22T05:17:19Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288419#M107254 <HTML><HEAD></HEAD><BODY><P>There is nothing here&nbsp; vikasmahajan. Here is what you should do on QlikCommunity:</P><P>look at any of the posts you've sent (preferably the latest above), <STRONG>Click </STRONG>on <STRONG>Edit. </STRONG>On the next page that appears, at the bottom, there is an option that allows you to<STRONG> 'Chose the file'</STRONG> you need to upload. Then <STRONG>Clik</STRONG> on<STRONG> 'Update'</STRONG> when you've finished chosen the file.</P><P>Regards.</P></BODY></HTML> Mon, 22 Aug 2011 09:38:17 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288419#M107254 2011-08-22T09:38:17Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288420#M107255 <HTML><HEAD></HEAD><BODY><P>Ok thanx, I got it. Will get back to you as soon as possible. </P><P>Regards.</P></BODY></HTML> Mon, 22 Aug 2011 14:14:08 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288420#M107255 2011-08-22T14:14:08Z how to get output using multiples fact tables https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288421#M107256 <HTML><HEAD></HEAD><BODY><P> Thanks in advanace sir , and shown interest to resolve issue</P></BODY></HTML> Tue, 23 Aug 2011 06:28:41 GMT https://community.qlik.com/t5/QlikView/how-to-get-output-using-multiples-fact-tables/m-p/288421#M107256 vikasmahajan 2011-08-23T06:28:41Z