topic Re: Date Difference in Dimension in QlikView

Date Difference in Dimension

Wed, 25 Feb 2015 05:55:53 GMT

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

Re: Date Difference in Dimension

amit_saini — Wed, 25 Feb 2015 06:06:31 GMT

Masba,

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

Thanks,

Re: Date Difference in Dimension

CELAMBARASAN — Wed, 25 Feb 2015 06:07:15 GMT

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.