topic Re: Multiple conditons in where clause in QlikView

Multiple conditons in where clause

Tue, 15 Apr 2014 14:05:42 GMT

Hi,

How can we put multilple conditions in where clause on load script. in below script i have to write two conditions in where clause like where CYEAR< year(today()) and CYEAR>year(Today())-3

load
V.SEGMENT as segment,
CYEAR as Year,
MARKET1 as Market,
Resident V
where CYEAR < year(Today())-3;

Re: Multiple conditons in where clause

jagannalla — Tue, 15 Apr 2014 14:11:57 GMT

Where CYEAR >Year(Today())-3 and CYEAR< Year(Today())

Re: Multiple conditons in where clause

Tue, 15 Apr 2014 14:23:50 GMT

Jagan,

i have tried with AND but its not working. is this because of resident load?

Re: Multiple conditons in where clause

richard_pearce6 — Tue, 15 Apr 2014 14:26:28 GMT

You can also enclose them in brackets if you need to add any 'or' statements at a later date

load
V.SEGMENT as segment,
CYEAR as Year,
MARKET1 as Market,
Resident V
where (CYEAR > year(Today())-3 and CYEAR < year(Today()) );

Re: Multiple conditons in where clause

Anonymous — Tue, 15 Apr 2014 14:30:10 GMT

I would use brackets to separate the 2 conditons between "and"

where ((CYEAR>year(today()-3) and (CYEAR<year(today()))

Re: Multiple conditons in where clause

its_anandrjs — Tue, 15 Apr 2014 14:37:29 GMT

Try to use like

Let vCurrYear = Year(Today());

Let vPrevYear = Year(Today())-3;

load
V.SEGMENT as segment,
CYEAR as Year,
MARKET1 as Market,
Resident V
where (( CYEAR > $(vPrevYear) ) and ( CYEAR < $(vCurrYear) ) );

Hope this helps

Re: Multiple conditons in where clause

maxgro — Tue, 15 Apr 2014 15:11:34 GMT

and works with resident load

where CYEAR > year(today()) - 3 and CYEAR < year(Today())

Re: Multiple conditons in where clause

antoniotiman — Tue, 15 Apr 2014 15:21:16 GMT

Try

CYEAR > (year(today()) -3) and ....