topic SQL Statement in QlikView in QlikView

SQL Statement in QlikView

Wed, 25 Nov 2020 16:16:04 GMT

Hello all

I'm hoping someone can help. I'm fairly new to QlikView but am trying to replicate the following SQL statement into a QV script. Is anyone able to help at all?

case when FIELD1/(1+((FIELD1-1)*16)/(50*50*2.69)) <= FIELD2 then 1 else 0 end

Thanks

Dan

Re: SQL Statement in QlikView

Anil_Babu_Samineni — Tue, 15 Aug 2017 15:37:05 GMT

May be this? I assume, FIELD1 and FIELD2 are numbers?

If(FIELD1/(1+((FIELD1-1)*16)/(50*50*2.69)) <= FIELD2, 1, 0) as Flag

Re: SQL Statement in QlikView

Wed, 16 Aug 2017 09:00:24 GMT

Thank you Anil. This works perfect.

Kind regards

Dan