Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

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
Highlighted

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

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

Highlighted
Not applicable

Thank you Anil. This works perfect.

Kind regards

Dan