Reports generate by age of date

[Anonymous]

Dear All,

I need calendar selection for below criteria is that

I have MS navision and my user looking customer receivables report from navision apps.

They select date as "Aged as of"

I have taking all required table from navion to qlikview and I am getting right figure from QV but am not able to do date selection for aging

Like

we have to selection in navision

1. ageing by Due Date

2. ageing by Posting Date

My requirement is I want to generate  report till as of like 31.10.2016 by Posting date or Due date.

Thanks

[Anonymous]

Any suggestion ???

[Anonymous]

Hi,

Are you looking for age as of today?

Requesting you to enplane your problem little more as its not giving full clarity.

Thanks,

[Anonymous]

No I want as of 31.10.2016 or whatever user will select...

[Anonymous]

Means you are looking for  age from DueDate-Posting date?

Thanks,

[miskin_m]

Hi,

Create two age buckets by due date and posting date, if ageing is always as of today. Can use toggling of button to enable the respective ageing bucket expression by conditional expression of due bucket ageing and posting bucket ageing.

[Anonymous]

Hi Miskin

I will create two buckets but how can we show report

as anyone one want report say 01.04.2009(first date ) to 31.10.2016 (as of date)  by due date

or

01.04.2009(first date ) to 31.10.2016 (as of date)  by  posting date

Thanks

[miskin_m]

Hi

PFA..

Used toggling of button to select posting date and due date ageing

[Anonymous]

Hi Vijay,

You can use following expression for getting ageing from selected dates:

GetFieldSelections(DueDate)-GetFieldSelections(PostingDate)

from above you will difference in days (ageing in days) from selected dates of DueDate and PostingDate

Thanks,