Date Difference in Dimension

[#1]

Dear all,

I'm new in Qlikview. I have two date fields..One is PO_DATE and another is INVOICE_DATE. I want to use difference between tow dates in "Dimensions" as a number (like 2., 3, 5 etc.) and in expression "Sum of Invoice Qty".

For Date between i have formula: =Ceil(Interval(Date#(PO_DATE, 'MM/DD/YYYY') - Date#(Invoice_DATE, 'MM/DD/YYYY'), 'DD' )). Can any one help me to show date difference number in "Dimension"

Regards,

Masba

[amit_saini]

Masba,

This I have already suggested to you, once again check attachments.

Thanks,

AS

[CELAMBARASAN]

You could try with Aggr function and unique ID - OrderID/InvoiceID

=Aggr(Ceil(Interval(Date#(PO_DATE, 'MM/DD/YYYY') - Date#(Invoice_DATE, 'MM/DD/YYYY'), 'DD' )), [OrderID/InvoiceID])

But for the Best practices and performance, don't do any calculation in dimension instead create this field in script and make use of it in presentation.