topic Populating missing data for dates where product / department / location have no volume in QlikView https://community.qlik.com/t5/QlikView/Populating-missing-data-for-dates-where-product-department/m-p/749185#M471817 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">I was able to get a good answer from this community when I only needed to populate missing data for product and date but now I need to improve my data set.&nbsp; I've attached example files.&nbsp; </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">I'm trying to populate this missing data in order to accurately calculate average and standard deviation for products, departments, and locations over a given timeframe.</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I need to be able to populate a table with every combination of Product, Department, Location, Date, and Volume.&nbsp; For every product I should have every department, every location, and every date, showing zero if volume is not found.&nbsp; Make sense?&nbsp; </P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 8pt;"><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Previous post with just product, date, and volume: </SPAN><A href="https://community.qlik.com/message/569001"></A></SPAN></P></BODY></HTML> Thu, 19 Feb 2015 04:58:40 GMT Anonymous 2015-02-19T04:58:40Z Populating missing data for dates where product / department / location have no volume https://community.qlik.com/t5/QlikView/Populating-missing-data-for-dates-where-product-department/m-p/749185#M471817 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">I was able to get a good answer from this community when I only needed to populate missing data for product and date but now I need to improve my data set.&nbsp; I've attached example files.&nbsp; </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">I'm trying to populate this missing data in order to accurately calculate average and standard deviation for products, departments, and locations over a given timeframe.</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I need to be able to populate a table with every combination of Product, Department, Location, Date, and Volume.&nbsp; For every product I should have every department, every location, and every date, showing zero if volume is not found.&nbsp; Make sense?&nbsp; </P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 8pt;"><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Previous post with just product, date, and volume: </SPAN><A href="https://community.qlik.com/message/569001"></A></SPAN></P></BODY></HTML> Thu, 19 Feb 2015 04:58:40 GMT https://community.qlik.com/t5/QlikView/Populating-missing-data-for-dates-where-product-department/m-p/749185#M471817 Anonymous 2015-02-19T04:58:40Z