topic Re: Looking for Ageing Analysis for Forcasting in QlikView

Looking for Ageing Analysis for Forcasting

Fri, 27 Jul 2012 05:13:16 GMT

Hi,

I have a Ticket with departure date and I would like to know the days prior to departure as mentioned below

Difficulties:

Last week DPD ( days prior to departure ) Values was in the 90days cell next week it will jump to 60days cell

Thx in Advance for the Help

brenner_martina — Fri, 27 Jul 2012 09:20:45 GMT

Hi,

I think the class-function can help you, look at the example.

Greetings from Munich

Martina

Mon, 30 Jul 2012 05:13:40 GMT

Hi,

Thank you Martina for replay.

Actually the requirement is

Look at the Highlighted 13 tickets will be in 90dpd for the first week 60dpd for the second week and 30dpd for third week.

Data should be represented in this manner

As per the Analysist he assumes wat is the Age of the Ticket and plans for the month.