Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Dual If (and) statements

I am having a hard time to elaborate this formula on QlikView. I am new with the system. Could someone help me please.

=If(And("Goals Quantification"=1,Actual-Goal<0,"Red","Green",If(And("Goals
Quantification"=2,Goal-Actual>0,"Green","Red")))

Thanks.

2 Replies
lironbaram
Honored Contributor II

Re: Dual If (and) statements

hi

try this

=If("Goals Quantification"=1 and Actual-Goal<0,"Red","Green",If("Goals

Quantification"=2 and Goal-Actual>0,"Green","Red"))

Re: Dual If (and) statements

May be this:

=If([Goal Quantification] = 2 and Goal - Actual > 0, Green(), Red())

Community Browser