topic Re: database column where condtion in QlikView

database column where condtion

Tue, 05 Aug 2014 05:47:38 GMT

Hi,

I need to fetch the column from db where the values lies between 100 to 1000.

the coumn name is Salary and my codition is to fetch the Salary from db where count of salary between 100 and 1000.

how to writhe above while condition while fetching from db with in the script not in the expression part.

provide me the solution

Re: database column where condtion

ashfaq_haseeb — Tue, 05 Aug 2014 05:50:08 GMT

Hi try below

Load

EMPID,

Ename,

Salary;

sql select * from table

Where Salary >100 and Salary <1000;

Regards

ASHFAQ

Re: database column where condtion

jjordaan — Tue, 05 Aug 2014 05:56:00 GMT

Hi,

You can use a query like;

SELECT

Field1

,Field2

,COUNT(Salary)

FROM table

WHERE Field3 = ?? (if you need to filter)

GROUP BY Field1, Field2

HAVING COUNT(Salary) >= 100 AND COUNT(Salary) <= 1000.

Hope this helps

Re: database column where condtion

senpradip007 — Tue, 05 Aug 2014 06:03:17 GMT

Try like:

Select * from [Your Table] where salary between 100 and 1000;

Re: database column where condtion

vardhancse — Tue, 05 Aug 2014 06:06:50 GMT

we can write the where condition after table name.

Re: database column where condtion

Tue, 05 Aug 2014 06:17:33 GMT

Hi Guys ,

its not working can you check from your end

Re: database column where condtion

jjordaan — Tue, 05 Aug 2014 19:46:49 GMT

Do you receive an error?

Can you be a bit more specific

Re: database column where condtion

joshabbott — Tue, 05 Aug 2014 19:56:17 GMT

We probably need a bit more information before we can answer. Is your datasource a spreadsheet? Access DB? SQL Server DB? No matter what it is, you should be able to get it using a preceding load, add the bolded below:

[Table Name You Define]:

LOAD *;

ALL OF YOUR LOAD SCRIPT HERE

Where [Plug Your DB Field Name Here] >= 100 and [Plug Your DB Field Name Here] <= 1000;

Re: database column where condtion

Wed, 06 Aug 2014 16:09:43 GMT

Josh Abbott,

Thanks for your solution.

Your approach is correct.

Thank you

Re: database column where condtion

Wed, 06 Aug 2014 16:12:38 GMT

Hi please close the question and make it as correct answer