topic Re: Limit or Exclude by invoice due date in QlikView

Limit or Exclude by invoice due date

Fri, 20 Nov 2020 18:02:30 GMT

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?

Re: Limit or Exclude by invoice due date

bbi_mba_76 — Tue, 06 May 2014 14:07:13 GMT

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

Re: Limit or Exclude by invoice due date

Tue, 06 May 2014 14:16:12 GMT

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

Re: Limit or Exclude by invoice due date

bbi_mba_76 — Tue, 06 May 2014 14:24:55 GMT

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