I have a table in qlikview that displays monthly sales for year selected and for previous year, I am creating a report in NPrinting with this table and I have a level 'Product Type', My issue is for one of the 'Product Types' there are no sales for 2016 which is the year selected in the filter, so the report doesn't loop through that Product Type, but I have sales in 2015 for that product type. If I select/filter year 2015 it will show sales numbers for 2015 and 2014 which will not be accurate. How can I force the report to loop through all the products types whenever they were sold 2015 or 2016?
