topic issue while comparing date analysis in QlikView

issue while comparing date analysis

sunil1989 — Tue, 07 Mar 2017 10:51:34 GMT

Hi ,

Thanks in advance.

i am new to qlik ,

i am having straight table in that i have to calculate the result on the basis of delivery date and payment date.

if payment date is greater than delivery date than it should give sum(final amount) my expression is below

=Sum({<paymentCompletionDateTime={">$(=actualDeliveryDateTime)"}>}finalTotalAmount)

its giving me result when i am selecting the true date in table , otherwise its showing me 0.

PrashantSangle — Tue, 07 Mar 2017 10:55:01 GMT

Hi,

If both field coming from same table then

create flag in script like

if(payment_date>delivery_date,'T','F') as flag,

then in front end use expression like

sum({<flag={"T"}>}finalTotalAmount)

Regards,

Prashant

tresB — Tue, 07 Mar 2017 10:55:16 GMT

Try like:

=Sum({<paymentCompletionDateTime={"=paymentCompletionDateTime>actualDeliveryDateTime"}>}finalTotalAmount)