topic Outstanding days in Set Analysis in QlikView

Outstanding days in Set Analysis

Tue, 07 Feb 2012 09:34:58 GMT

Dear All,

I would like to know how to find the outstanding days .

I have attached the sample excel file.

could anyone help me.

thanks in advance.

Re: Outstanding days in Set Analysis

jagan — Tue, 07 Feb 2012 11:17:15 GMT

Hi,

Please check the attached file for solution.

Regards,

Jagan.

Outstanding days in Set Analysis

Tue, 07 Feb 2012 12:01:11 GMT

thanks for the reply.

I need to show the outstanding amount ant the days.

Your application shows the normal days.

its not checking whether its having outstanding amount.

to check we have to consider the ID field for amount.

to calculate the days we have to consider the ID and starting Voucher no and Voucher date.

Re: Outstanding days in Set Analysis

jagan — Tue, 07 Feb 2012 12:32:23 GMT

Hi,

Please check the attached file. Hope this helps you.

Regards,

Jagan.

Outstanding days in Set Analysis

Wed, 08 Feb 2012 04:36:14 GMT

thanks for ur reply.

we have to consider the first invoice date.

For ex, Category A and ID 2 for Jan

the outsatnding amount is 500-250=250

the outstanding days is 31/01/2012-12/20/2011=42

dont consider the partial payments..

they paid 250 on 01/20/2012 but the actual amt is 500 raised on 12/20/2011

we have to consider the 12/20/2011.

thanks in advance

Re: Outstanding days in Set Analysis

jagan — Wed, 08 Feb 2012 04:47:54 GMT

Hi,

Please check the updated attachment for solution.

Regards,

Jagan.

Outstanding days in Set Analysis

Wed, 08 Feb 2012 06:19:37 GMT

thanks for ur response...

when i remove the ID field from the chart.

the values getting mismatched. also i need to show in pivot table.

I wont Show the ID fields

Outstanding days in Set Analysis

jagan — Wed, 08 Feb 2012 06:52:13 GMT

Hi,

If you remove ID then the chart works based on Category and ID is not considered. So, all calculations are done based on the Category.

Regards,

Jagan.