QlikView Zero Line Fix

//Loading all existing combinations to ensure that unnecessary rows are not concatenated & creating temporary table (which will be smaller than real-world fact table)
fact_temp:
LOAD DISTINCT
      DATE_KEY,
      PRODUCT_ID,
      TERRITORY_ID,
      DATE_KEY & '|' & PRODUCT_ID as date_prod_exists,
      DATE_KEY & '|' & TERRITORY_ID as date_terr_exists
RESIDENT Fact;

dates1:
LOAD DISTINCT DATE_KEY RESIDENT fact_temp;

dates2:
NOCONCATENATE LOAD DISTINCT DATE_KEY RESIDENT fact_temp;

JOIN (dates1) LOAD DISTINCT PRODUCT_ID RESIDENT fact_temp; //Cartesian join to create all combinations of dates and products

CONCATENATE (Fact) LOAD //adding those date-product combinations that do not already exist in Fact
      *,
      0 as TRx
RESIDENT dates1
WHERE NOT exists(date_prod_exists,DATE_KEY & '|' & PRODUCT_ID)
;

JOIN (dates2) LOAD DISTINCT TERRITORY_ID RESIDENT fact_temp; //Cartesian join to create all combinations of dates and products

CONCATENATE (Fact) LOAD //adding those date-territory combinations that do not already exist in Fact
      *,
      0 as TRx
RESIDENT dates2
WHERE NOT exists(date_terr_exists,DATE_KEY & '|' & TERRITORY_ID)
;

DROP TABLES dates1,dates2;

• Create a flag in your Calendar table to indicate the relevant weeks that you want to view. In our example, this field is called #Last13WeeksFlag and will have a value of '1' for the most current 13 weeks of data.
• Assuming your Product coloring field is called ProductColor, set your chart expression background expression to the following: only({1<#Last13WeeksFlag={1},Product=P({<#Last13WeeksFlag={1}>}Product)>} ProductColor)
• Under Presentation, uncheck the "Suppress Zero Values" checkbox.

• If you have not already done so in Method #1 above, create a flag in your Calendar table to indicate the relevant weeks that you want to view. In our example, this field is called #Last13WeeksFlag and will have a value of '1' for the most current 13 weeks of data.
• Assuming your chart expression is something like sum({<#Last13WeeksFlag={1}>} TRx) modify the expression to the following:
  

  if(sum({<#Last13WeeksFlag={1}>} TRx)>0,
       sum({<#Last13WeeksFlag={1}>} TRx),
       sum({1<#Last13WeeksFlag={1},Territory=P({<#Last13WeeksFlag={1}>}Territory)>} 1) - sum({1<#Last13WeeksFlag={1},Territory=P({<#Last13WeeksFlag={1}>}Territory)>} 1)
  )

• Under Presentation, uncheck the "Suppress Zero Values" checkbox.