Conditional Expression not working

[#1]

Hi,

I need to implement the following logic inside a measure:

If (DATE_ID >=1465 or DATE_ID <=1556) then Sum( Field1- (Field 2+Field 4)/ Sum(Field 3)

I tried using an expression : Sum({<DATE_ID ={">=1465"}>}  {<DATE_ID ={"<=1556"}>} (Sum( Field1- (field 2+Field 4)/ Sum(Field 3)))

The expression doesn't work.probably because it has multiple operators.

Please suggest a solution.

Thanks

[Josh_Good]

Hi Soumya,

I think you just have a minor syntax issue. Try this:

Sum({<DATE_ID ={">=1465"}>}, DATE_ID ={"<=1556"}>} Field1- (field 2+Field 4)/ Sum(Field 3))

-Josh

Qlik

Please mark my response as helpful or correct so other member can find answers more quickly.

[rubenmarin · Accepted solution]

Just a minor change:

Sum({<DATE_ID ={">=1465<=1556"}>} Field1- (field 2+Field 4)/ Sum(Field 3))

[Josh_Good]

Thanks Ruben.  I missed that!

-Josh

[#5]

I tried using this expression:  Sum({<DATE_ID ={">=1465<=1556"}>} Field1- (field 2+Field 4)/ Sum(Field 3))

When I use the Sum function inside expression 'Sum(Field3)'. It says expression is wrong. And If I leave the 'Sum' function out, there's no error but the division part is not working in the calculation.

[Josh_Good]

Try this:

Sum({<DATE_ID ={">=1465<=1556"}>} Field1- (field 2+Field 4)/ Field 3)

-Josh

Qlik

[#7]

This function checks:

if(DATE_ID >=1465,if(DATE_ID <=1556,sum( Field1- (Field 2+Field 4)/ Sum(Field 3)))

[#8]

Thank you all. I used the expression to create a variable. It's working.

[rubenmarin]

Maybe one of these:

Sum({<DATE_ID ={">=1465<=1556"}>} Field1- (field 2+Field 4))/ Sum({<DATE_ID ={">=1465<=1556"}>} Field 3))

Sum({<DATE_ID ={">=1465<=1556"}>} (Field1- (field 2+Field 4))/ Field 3)

[oknotsen]

If your question is answered, please flag correct and helpful answer(s).