Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Try like:
=Sum({<paymentCompletionDateTime={"=paymentCompletionDateTime>actualDeliveryDateTime"}>}finalTotalAmount)