topic Re: Trouble using Where Clause in QlikView

Trouble using Where Clause

Thu, 23 Oct 2014 21:33:42 GMT

I only want to see certain data from a specific field in a table. I have tried using several where clauses, but all fields keep loading in.

Here is what I have in my script:

SQL Select UserDefined1

FROM dbo.tblIncidentUtilityCross

WHERE UserDefined1 = 'New Customer', 'Existing Customer', 'New Dealer', 'Existing Dealer';

Any help would be appreciated.

Thanks

Re: Trouble using Where Clause

jerem1234 — Thu, 23 Oct 2014 21:42:58 GMT

Try:

SQL Select UserDefined1

FROM dbo.tblIncidentUtilityCross

WHERE UserDefined1 in ('New Customer', 'Existing Customer', 'New Dealer', 'Existing Dealer');

Hope this helps!

Re: Trouble using Where Clause

Thu, 23 Oct 2014 21:47:19 GMT

I tried that and it still gave me all values in the field

Re: Trouble using Where Clause

jerem1234 — Thu, 23 Oct 2014 21:54:20 GMT

hmm its working for me, do you have another table that just has the UserDefined1 field?

Re: Trouble using Where Clause

Thu, 23 Oct 2014 21:58:25 GMT

yes that field it is in multiple tables

Re: Trouble using Where Clause

jerem1234 — Thu, 23 Oct 2014 22:02:22 GMT

Try this and see if you get the correct values in your table:

TableTest:

SQL Select UserDefined1 as UserDefined1Test

FROM dbo.tblIncidentUtilityCross

WHERE UserDefined1 in ('New Customer', 'Existing Customer', 'New Dealer', 'Existing Dealer');

If you do, then your table is being automatically concatenated to another table that has all the values. I don't know what you are doing in your script, so I can only guess.

Re: Trouble using Where Clause

MarcoWedel — Thu, 23 Oct 2014 22:04:51 GMT

LOAD *

Where Match(UserDefined1, 'New Customer', 'Existing Customer', 'New Dealer', 'Existing Dealer');

SQL Select UserDefined1

FROM dbo.tblIncidentUtilityCross;

hope this helps

regards

Marco

Re: Trouble using Where Clause

Thu, 23 Oct 2014 22:59:04 GMT

Thanks that worked. really appreciate it

Re: Trouble using Where Clause

Fri, 24 Oct 2014 04:29:06 GMT

Hi Toedtli,

In case you are having a problem of tables getting concatenated due to same column names.

You can also use Qualify which names the fields as Tablename.FieldName making the fields unique preventing concatenation.

1. For all fields: QUALIFY *

2. For specific fields QUALIFY fieldname1, fieldname2

3. Use UNQUALIFY * or UNQUALIFY fieldname1, fieldname2 when you want to disable this functionality.

Thanks,

Shoubhik.

Re: Trouble using Where Clause

jyothish8807 — Fri, 24 Oct 2014 04:56:31 GMT

Hi Toedtli,

Try using Match function in your script which works equivalent to IN in your SQL Script.

Load

where Match(UserDefined1,'New Customer', 'Existing Customer', 'New Dealer', 'Existing Dealer');

Hope it helps.

Regards