Limit or Exclude by invoice due date

[#1]

I am new to Qlikview and have ran into an issue that I am unable to resolve. We have created an AR Aging report which loads all data which includes total balances due by customer. We are attempting to limit the report to show only customers that have invoices that are overdue or due within 7 days from the present date but have been unable to do so. How can we limit what is shown but also load all of the data?

[bbi_mba_76 · Accepted solution]

Hi,

without the document is not so easy, maybe you could add a calculated dimension with the difference between the two dates: If(today()-DueDate>=7, 1) and use the suppress when value is null

[#3]

That was incredibly fast and helpful AND it worked. Can we exclude the calculated dimension from the pivot table?

[bbi_mba_76]

there is a macro to set the column width to zero

sub HideFreqPivotColumn

    set obj = ActiveDocument.GetSheetObject("CH137")

    set objProp = obj.GetProperties

    set objDim = objProp.Dimensions

    objDim(1).ColWidth = 0

    obj.SetProperties objProp

end sub