I have one formula which is written in excel.

[KommulaRahul]

Can anyone come up with an appropriate Expression on how to replicate the same expression in Qlik by using set analysis . Pls look into the attachment below for the  Excel formula

[Aurelien_Martinez]

HI,

You can try an expression like:

IF(Len([Delivered formatted])=0,
  If([Order status]='Delivered',
    If([Delivery window starttime] <= [Delivered formatted],
      If([Delivered formatted] <= [Lastest delivery endtime], 'TRUE', 'FLASE')
      'FALSE'
    )
  )
)
 

[KommulaRahul]

I tried this expression but the resultant output we get is true or false. It's in a text format

I want the result in the form of number(Eg 3422) 

So can u write this expression by using Count

[G3S]

the true & false can be replaced with 1 and 0. then you can sum it.

[Gabbar]

Use the same expression which you have used in Excel, it should work properly, 
IF it is showing null, aggregate it with a respective primary key dimension.