if then conditions

[#1]

Post Title: IF else condition

Hello I present myself, I am new to this forum and QlikView also, (even if I was looking at from a certain moment)

I work on QlikView for less than a month.

I have a problem with the script for an IF condition:

I would like to do; IF vriableA> variableB 6 or> 35 or variableC> 13 Then the field value is equal to "Yes" or if the field value = "Name"

I hope I was clear, thank you in advance

[#2]

Hi Teneman,

Your question is not clear.  It would help if you provide a small sample set of data (just a couple of rows) and expected results.

Ahmet

[robert_mika]

This bit

Could you post your if statement  again?

This parts

I would like to do; IF vriableA> variableB 6 or> 35 or variableC> 13 Then the field value is equal to "Yes" or if the field value = "Name"

are not very clear:

[rubenmarin]

Hi, not sure but maybe this:

If(variableA>6 or variableB>35 or variableC>13 or [field value] = 'Name', 'Yes' , 'No')

Syntaxis is:

If(Conditions, ResultIfTrue, ResultIfFalse)

[MarcoWedel]

Hi,

you would have to create a logical expression that is syntactically correct (you can see from the red curved lines in the editor if it isn't).

Your example is not a valid expression. Try to explain with words rather than code if that helps, maybe we can help then.

regards

Marco

[#6]

Hi,

How to check for Null values in an IF Statement?

Thanks,

Bryan

[#7]

Ok got it:

example:

If (isnull(LeftDate),'Active','Left')