Ageing Analysis Report issues

Mon, 03 Dec 2012 09:05:32 GMT

Hi,

i am trying to do ageing analysis based on the dates available in the field.

Ex:

(Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 0,'Today',
IF(Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 1,'1day',) )As OpenTime

I have modified the format of data and when i use this in expression in the report it returns me the number but when i upload it in main edit script page and reload the script, i dont get any values in newly created 'OpenTime' column.

Please guide.

Re: Ageing Analysis Report issues

Tue, 04 Dec 2012 19:51:12 GMT

expression

Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY')

gives 0 if today()=first day of month and [Submit Date] = today()

gives 1 if today()=second day of month and [Submit Date] = yesterday

what i mean is your condition probably never is true

topic Re: Ageing Analysis Report issues in QlikView

Ageing Analysis Report issues

Re: Ageing Analysis Report issues