Condition in expression

[narender123]

Hi team,

I want a expression in table like this:

IF TP_YEAR IS NOT NULL THEN

SUM(AMOUNT) WHERE FIRST_YEAR<v(YEAR)

IF TP_YEAR IS NULL THEN

SUM(AMOUNT) WHERE SECOND_YEAR<v(YEAR)

IF BOTH ARE NULL THEN

SUM(AMOUNT)

I want to set all 3 condition .Pls give me suggestion to sort out.

Thanks,

Narender

[Peter_Cammaert]

The more (context) information you supply, the better the suggestions.

Script of Chart?

Which of the names in your pseudo-statement are QlikView fields?

What is your data model?

[alexandros17]

What do you mean for BOTH are null, Both ??

[narender123]

Hi Peter,

Thanks for your reply.

FOR FIRST CONDITION

LIKE:

=SUM({<FIRST_YEAR={"<$(vYEAR)"}>}AMOUNT)

here vYEAR is varible means max(year) 

I want to include all condition as i wrote in my question above.

Thanks,

[narender123]

Hi Saccone,

Both means

FIRST_YEAR and SECOND_YEAR conditions are Null.

because at some place both condition(FIRST_YEAR and SECOND_YEAR)  heaving no value means null.At such situation i want all of them null year.

Thanks,

[alexandros17]

If(IsNull(TP_YEAR)=0,
Sum({$ <FIRST_YEAR={'<$(vYEAR)'}>} Amount),
If(IsNull(TP_YEAR)=-1,
Sum({$ <SECOND_YEAR={'<$(vYEAR)'}>} Amount),
If(BOTH are null ???,
Sum(Amount),
'Undefined'
)
)
)