topic Re: Conditional Expression not working in App Development

Conditional Expression not working

Thu, 08 Oct 2015 13:09:08 GMT

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

Re: Conditional Expression not working

Josh_Good — Thu, 08 Oct 2015 14:24:15 GMT

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.

Re: Conditional Expression not working

rubenmarin — Thu, 08 Oct 2015 14:31:31 GMT

Just a minor change:

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

Re: Conditional Expression not working

Josh_Good — Thu, 08 Oct 2015 15:20:02 GMT

Thanks Ruben. I missed that!

-Josh

Re: Conditional Expression not working

Fri, 09 Oct 2015 07:12:55 GMT

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.

Re: Conditional Expression not working

Josh_Good — Fri, 09 Oct 2015 17:47:40 GMT

Try this:

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

-Josh

Qlik

Re: Conditional Expression not working

Fri, 09 Oct 2015 20:02:11 GMT

This function checks:

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

Re: Conditional Expression not working

Sat, 10 Oct 2015 05:32:25 GMT

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

Re: Conditional Expression not working

rubenmarin — Sat, 10 Oct 2015 16:57:24 GMT

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)

Re: Conditional Expression not working

oknotsen — Sat, 10 Oct 2015 17:29:44 GMT

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