Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL Statement in QlikView

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

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Thank you Anil. This works perfect.

Kind regards

Dan