topic Sales Restriciton in QlikView https://community.qlik.com/t5/QlikView/Sales-Restriciton/m-p/360546#M704230 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am loading plan and sales data into Qlikview linking the two table with a deep enought key (year period, Customer, Item Number).</P><P></P><P>My issue is this: Once the data is loaded in The plan data is resticted to months that had sales for that particular Item. I need all the plan data to be shown, ireespective of sales,so I can draw the correct comparisons.</P><P></P><P>Any help would be much appreciated. </P><P></P><P>Richard</P></BODY></HTML> Wed, 20 Jun 2012 12:22:26 GMT 2012-06-20T12:22:26Z Sales Restriciton https://community.qlik.com/t5/QlikView/Sales-Restriciton/m-p/360546#M704230 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am loading plan and sales data into Qlikview linking the two table with a deep enought key (year period, Customer, Item Number).</P><P></P><P>My issue is this: Once the data is loaded in The plan data is resticted to months that had sales for that particular Item. I need all the plan data to be shown, ireespective of sales,so I can draw the correct comparisons.</P><P></P><P>Any help would be much appreciated. </P><P></P><P>Richard</P></BODY></HTML> Wed, 20 Jun 2012 12:22:26 GMT https://community.qlik.com/t5/QlikView/Sales-Restriciton/m-p/360546#M704230 2012-06-20T12:22:26Z Re: Sales Restriciton https://community.qlik.com/t5/QlikView/Sales-Restriciton/m-p/360547#M704231 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>to show all the dates u need to create a master calendar in ur data model which u will link with ur transactional date field.</P></BODY></HTML> Wed, 20 Jun 2012 13:02:59 GMT https://community.qlik.com/t5/QlikView/Sales-Restriciton/m-p/360547#M704231 2012-06-20T13:02:59Z