topic Re: comparing/ comining data in one chart with different date parameters in QlikView https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781400#M1046561 <HTML><HEAD></HEAD><BODY><P>hmm, I guess what i need is a way that I can get Qlik to see the monthly count of items sold rather than just the daily numbers ... then i can use these monthly totals to do the comparison I just cant figure out how to get these monthly totals to sit somewhere in the background so they can be selected as a chart etc option</P></BODY></HTML> Wed, 19 Nov 2014 15:22:24 GMT 2014-11-19T15:22:24Z comparing/ comining data in one chart with different date parameters https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781398#M1046559 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have loaded two tables into a qlik model</P><P></P><P>one has data in a day format which is wrapped up into a monthly result by renaming the date as monthname(date). the other has the montly forecast for the data and i need to compare the two on one chart. when i try and just load the data it is putting the forecast monthly data against every individual day data and therefore increasing my forecast by 30 times (or however many days are in the month). Any ideas on how to do this would be fab</P><P></P><P>thanks</P><P></P><P>as an example, i have attached a document with a really brief view of what my data may look like (not real data)</P><P></P><P>table a is my daily incoming data i have., table 2 is the monthly forecast I want to compare against. </P></BODY></HTML> Wed, 19 Nov 2014 14:47:52 GMT https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781398#M1046559 2014-11-19T14:47:52Z Re: comparing/ comining data in one chart with different date parameters https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781399#M1046560 <HTML><HEAD></HEAD><BODY><P>i would suggest a Key Id to your Tbale1, I'd assume it is a list of products sold by which you would want to compare it with Forecast sales of the month.</P><P></P><P>A master calendar will be nice to add Periods(in this case Month) to your corresponding transactions.</P></BODY></HTML> Wed, 19 Nov 2014 15:01:27 GMT https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781399#M1046560 jpenuliar 2014-11-19T15:01:27Z Re: comparing/ comining data in one chart with different date parameters https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781400#M1046561 <HTML><HEAD></HEAD><BODY><P>hmm, I guess what i need is a way that I can get Qlik to see the monthly count of items sold rather than just the daily numbers ... then i can use these monthly totals to do the comparison I just cant figure out how to get these monthly totals to sit somewhere in the background so they can be selected as a chart etc option</P></BODY></HTML> Wed, 19 Nov 2014 15:22:24 GMT https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781400#M1046561 2014-11-19T15:22:24Z Re: comparing/ comining data in one chart with different date parameters https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781401#M1046562 <HTML><HEAD></HEAD><BODY><P>you can have a combo Bar/Line to present your data,</P><P>on the Bar, you can have Monthly Sales of Products,</P><P>Line: Monthly forecast</P></BODY></HTML> Wed, 19 Nov 2014 15:32:24 GMT https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781401#M1046562 jpenuliar 2014-11-19T15:32:24Z Re: comparing/ comining data in one chart with different date parameters https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781402#M1046563 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar</A></P></BODY></HTML> Wed, 19 Nov 2014 15:35:04 GMT https://community.qlik.com/t5/QlikView/comparing-comining-data-in-one-chart-with-different-date/m-p/781402#M1046563 jpenuliar 2014-11-19T15:35:04Z