topic Re: If expressions in QlikView

If expressions

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to write an expression to return a date when the OrderStatus is Cancelled.

If(OrderStatus ='Cancelled',SendingTime)

I thought the above would work, however it doesn't return any results.

I would appreciate any help with this issue.

Thanks,

Daniel

Re: If expressions

sunny_talwar — Wed, 10 Aug 2016 16:29:33 GMT

Are you sure this will be a single date? May be there are more than one dates, try concat to see if there are more than one dates here:

Concat(Distinct If(OrderStatus ='Cancelled', SendingTime))

Re: If expressions

danielnevitt — Wed, 10 Aug 2016 16:41:44 GMT

Thanks Sunny, that works perfectly.

I was also trying to show the time difference between the order entry (SendingTime) and the cancellation. Date format is dd/mm/yyyy hh:mm:ss. Is this possible?

Thanks

Re: If expressions

Clever_Anjos — Wed, 10 Aug 2016 16:42:14 GMT

Maybe you have more than one try

Min({<OrderStatus ={'Cancelled'}>}SendingTime)

Re: If expressions

sunny_talwar — Wed, 10 Aug 2016 16:44:39 GMT

How would you want to show this for multiple entries?

Re: If expressions

danielnevitt — Wed, 10 Aug 2016 16:47:38 GMT

The field linking each record is the ClOrdID. If there are say three records and the last is cancelled, I would like to show the difference between the first = min(SendingTime) and cancelled date Concat(Distinct If(OrderStatus ='Cancelled', SendingTime))

Hope that makes sense?

Regards,

Daniel

Re: If expressions

sunny_talwar — Wed, 10 Aug 2016 16:49:45 GMT

I think cleveranjos‌'s solution make sense here:

Min(SendingTime) - Min({<OrderStatus = {'Cancelled'}>} SendingTime)