Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

How to show ageing analysis report in qlikview

Dear All

I have sql procedure to calculate ageing oustanding for customer's as on date i/e current date ,Now suppose I want to see

backdated oustanding i.e as off 31/03/2013  , Then What to do in qlikview ?

Thanks

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
2 Replies
Not applicable

Hi Vikas,

Create a variable and assign the variable with the 31/03/2013.

Then, calculate the buckets using the the variable and the customer O/S date.

Hope this helps.

Regards,

Snehal Nabar

vikasmahajan
Author

Thanks Snehal,

How are you ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.