topic Re: Constraint while using Expression in QlikView

Constraint while using Expression

Thu, 24 Apr 2014 12:56:49 GMT

Hello everyone,

I am in need of help like always

I am trying to add a constraint while I am using an expression. What I want to do is this;

I have a regions which are Aegean, Mediterranean and Marmara. I have the List Box ready but here comes the tricky part. I pull this data from SQL Table of mine and there are other regions other than I mentioned before but I only want to show these regions and filter that way. How will I be able to do that?

Re: Constraint while using Expression

alexandros17 — Thu, 24 Apr 2014 13:02:13 GMT

Let's suppose that your table name is MYTAB while other tables yet existing are TAB1, TAB2 and so on.

The best thing is to inner join TAB1 and others with your in this way:

Load * resident TAB1;

inner join

Load distinct region resident MYTAB;

In this way you are excluding in all other tables regions not contained inn your table

hope it helps

Re: Constraint while using Expression

Thu, 24 Apr 2014 13:05:13 GMT

I understand the main problem is that Region is also in the same table so I won't be able to do that

Re: Constraint while using Expression

Thu, 24 Apr 2014 13:06:27 GMT

write the below expression in list box expression:

if(wildmatch(Region,'Aegean', 'Mediterranean',' Marmara'),Region)

Hope this will help u..!

Re: Constraint while using Expression

PrashantSangle — Thu, 24 Apr 2014 13:06:55 GMT

Hi,

Try WHERE clause in your SQL Query.

Select * from tableName

Where region='Aegean' or region='Mediterranean' or region='Marmara'

Regards,

Re: Constraint while using Expression

Thu, 24 Apr 2014 13:10:03 GMT

You can write SQL script in ur scripting like;

SQL select * from table_name

wher Region in('Aegean', 'Mediterranean','Marmara');

Re: Constraint while using Expression

Thu, 24 Apr 2014 13:11:54 GMT

Thank you, got it to work without doing it in the query

also can I use something like, if I cannot how can I do it? Write a query?

if(wildmatch(Region,'Aegean' as EGE, 'Mediterranean' as Antalya,' Marmara' as Istanbul),Region)