topic Re: If Statement in QlikView

If Statement

Thu, 07 Feb 2013 12:27:01 GMT

What is wrong?

The question works if I comment "if(c.country_id='1', 'SE', 'annat_land') as Land,"

Buyers:

LOAD * ;

SQL select cu.email as [Email Address],

max(o.created_at) as last_order_date,

cu.identity_number,

if(c.country_id='1', 'SE', 'other') as Country,

c.country_id

from carts c

left join customers cu on c.customer_id=cu.id

left join orders o on o.cart_id=c.id

where o.created_at>'2010-01-01 00:00:00.000'

and o.order_status_id>'100'

group by cu.email,cu.identity_number,c.country_id;

/Julia

Re: If Statement

flipside — Thu, 07 Feb 2013 12:35:59 GMT

Hi Julia,

The line where you create the Country (Land?) field is not an aggregated (eg SUM) or single (eg MAX) value, so that column needs to be included in the group by clause. Alternatively you can move the creation of that field into the preceding LOAD portion (eg LOAD*, if(country_id='1' ...)

flipside

Re: If Statement

martin59 — Thu, 07 Feb 2013 12:36:34 GMT

Hi Julia,

Could you try this :

if(c.country_id=1, 'SE', 'annat_land') as Land,

I removed quotes

Hope that helps you

Martin

Re: If Statement

Thu, 07 Feb 2013 13:10:34 GMT

Thanks!