Greater than equal to >= in load script

[johngouws]

Good day all. 

I normally use >= in my set analysis but am wondering if there is a way of using >= in the load script? 

Thank you - stay safe..

[johngouws]

I unfortunately cannot share this now. 

I am going to leave it as is for now and re address when time is available. 

Thank you thow. 

[Mauritz_SA · Accepted solution]

I suspect that your Document Type is being seen as text. Try IF(Physical='1' and SearchType='4' and Num#(DocumentType)<=5,DiscountAmount) as [Total_Sale]

You could also use Match(DocumentType,3,4,5) if you want to fix the range. Might need to use Match(Num#(DocumentType),3,4,5).

[tresesco]

Hi @Mauritz_SA ,

That is a possibility, however, usually qlik engine is intelligent enough to convert such text-numbers to numbers internally.

[johngouws]

Thanks @Mauritz_SA 

I am going to try your options - Thank you.