How to write the below excel formula in qlik using set analysis

[KommulaRahul]

Look into the below attachment

[ajaykakkar93]

Hi,

Code from Excel to Qlik:

=if( LEN(TRIM([DELIVERED FORMATTED])) =0 , '' ,
	if( TRIM([ORDER STATUS]) = 'DELIVERED' , '•' ,
		if( [DELEVERY WINDOW STATRTIME] <= [DELIVERED FORMATTED] , TRUE ,
			if( [DELIVERED FORMATTED] <= [DELEVERY WINDOW ENDTIME] , FALSE ,
				'NA'		
			) 
		)
	)	
)

[KommulaRahul]

Can u write the same expression in Qlik

By using set analysis By using Count? 

[ajaykakkar93]

What exactly do you want to achieve provide a data set for better understanding.

[KommulaRahul]

Hi Ajay

Below are the fields 

1. POS Order NO

2.Order Status

3. Delivered (Not delivered formatted)

4.[ Delivery Window StartTime]

5.[Delivery Window EndTime]

So the logic is Count the Pos orders  where the 

Delivered field is less than Delivery Window Start time field

And Delivered field is more than the Delivered window End Time field and order status is equal to delivered

Can u come up with an expression using set analysis

[PrashantSangle]

set analysis used with aggregated function. But the formula which you share as image don't have any aggregated function. It is just comparing field and assigning value. 

I will recommend you to write this expression in Script only. 

or you have to use if statement which @ajaykakkar93 suggested.

Regards,

Prashant Sangle

[KommulaRahul]

Ignore the image in that attachment

Follow the one where I described about those five fields. 

[PrashantSangle]

then provide sample data & required output. It is difficult to understand.