topic Re: Issue with Where in the script in QlikView

Issue with Where in the script

alec1982 — Mon, 26 Jan 2026 18:19:17 GMT

Hi Guys,

I am having issue with using where in the script. If I comment the Where statement I get data and if I add it no data will show on the table.

I noticed that the issue is in the and in the where statement..but not sure how to fix

ActualYTDBalance:

Load

Year,

Period,

Name,

Sum(AmountYTD) as Amount

Resident AA2

where Name='1100' and Name='1105'

Group by Year,Period,Name;

Let me know if you can help!

Best,

Badr

Re: Issue with Where in the script

rbecher — Fri, 23 Aug 2013 22:19:04 GMT

Hi Badr,

it's an OR, the field can have only one value per record:

where (Name='1100' or Name='1105')

- Ralf

Re: Issue with Where in the script

MayilVahanan — Sat, 24 Aug 2013 05:29:23 GMT

Edit:

ActualYTDBalance:

Load

Year,

Period,

Name,

Sum(AmountYTD) as Amount

Resident AA2

where Match(Name,'1100','1105')

Group by Year,Period,Name;

If you use AND function, it does not display any value because, a single row contain single name

Re: Issue with Where in the script

jagan — Sat, 24 Aug 2013 08:25:56 GMT

Hi,

Instead of OR you are using AND condition, because a Name field cannot have two values at a time.

ActualYTDBalance:

Load

Year,

Period,

Name,

Sum(AmountYTD) as Amount

Resident AA2

where (Name='1100' OR Name='1105')

Group by Year,Period,Name;

Hope this helps you.

Regards,

Jagan.

Re: Issue with Where in the script

VishalWaghole — Sat, 24 Aug 2013 12:30:02 GMT

Try this One, May this will help you

ActualYTDBalance:

Load

Year,

Period,

Name,

Sum(AmountYTD) as Amount

Resident AA2

where Match(Name,'1100','1105')

Group by Year,Period,Name;

Re: Issue with Where in the script

alec1982 — Mon, 26 Aug 2013 14:34:35 GMT

Thank you guys! I totally missed the and , or differences