issue while comparing date analysis

[sunil1989]

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]

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

[tresesco]

Try like:

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