topic Re: Where clause in SQL not working in QlikView

Where clause in SQL not working

pauldamen — Mon, 26 Oct 2015 11:24:56 GMT

Hi,

I have a SQL load which i want to incorporate a where clause in. I have done it before but I can't seem to get it working now and I am not doing anything else.

My script looks like this:

SQL SELECT
ActualEnd,
ActualStart,
`lut_Event_Id` as EventID,
`lut_SponsorRevenue` as SponsorRevenue,
Name as CampaignName,
`OwnerId_Name` as UserName,
Id as CampaignID
ProposedEnd,
ProposedStart,
StateCode as CampaignStatus,
TypeCode as CampaignType
FROM CData.Campaign
where StateCode = 'Active';

Any idea what is going wrong?

Regards, Paul

Re: Where clause in SQL not working

swuehl — Mon, 26 Oct 2015 11:30:36 GMT

What do you mean with 'not working'?

Do you get an error message?

Or do you see more records with other StateCode than 'Active'?

What if you run only this code in a script (no further LOADs, with possible autoconcatenated records to your table)?

Re: Where clause in SQL not working

richard_chilvers — Mon, 26 Oct 2015 11:30:51 GMT

Paul

Does it fail (with error message) or just give unexpected results ?

Re: Where clause in SQL not working

jonathandienst — Mon, 26 Oct 2015 11:30:51 GMT

There is no comma after "Id as CampaignID"

Re: Where clause in SQL not working

pauldamen — Mon, 26 Oct 2015 12:08:16 GMT

Sorry guys forgot to attach the error screenshots (error is to long so I made 2 screenshots to capture the full sentence)

Find attached. I have never encountered that error before

Re: Where clause in SQL not working

vikasmahajan — Mon, 26 Oct 2015 12:11:19 GMT

check with StateCode filed whether it is 'Active' , I think it should have some different values

Vikas

Re: Where clause in SQL not working

pauldamen — Mon, 26 Oct 2015 12:15:02 GMT

I checked but in the preview it gives me the exact values.

Regards, Paul

Re: Where clause in SQL not working

pauldamen — Mon, 26 Oct 2015 12:24:48 GMT

Guys, I found it.

Your post got me thinking Vikas so I tried, Statuscode = '1' instead of Active and this worked! For some strange reason all the previews show the name but somewhere under water in the database it is called 0 and 1

Regards ,Paul

Re: Where clause in SQL not working

swuehl — Mon, 26 Oct 2015 12:26:04 GMT

I think there is some kind of enum used for that field.

Re: Where clause in SQL not working

vikasmahajan — Tue, 27 Oct 2015 03:52:52 GMT

you can mark correct ans to those post who have given you correct feedback.

Vikas