topic Re: Condition in expression in QlikView

Condition in expression

narender123 — Tue, 03 Feb 2015 09:44:12 GMT

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

Re: Condition in expression

Peter_Cammaert — Tue, 03 Feb 2015 09:51:12 GMT

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?

Re: Condition in expression

alexandros17 — Tue, 03 Feb 2015 09:53:38 GMT

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

Re: Condition in expression

narender123 — Tue, 03 Feb 2015 10:01:34 GMT

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,

Re: Condition in expression

narender123 — Tue, 03 Feb 2015 10:05:49 GMT

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,

Re: Condition in expression

alexandros17 — Tue, 03 Feb 2015 10:08:02 GMT

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'
)
)
)