topic Re: Where condition while fetching data from Qvds in QlikView

Where condition while fetching data from Qvds

rsdhavle — Mon, 14 Jul 2014 12:09:50 GMT

Hi,

How can we put where condition while fetching data from QVDs?

Is it possible?

Re: Where condition while fetching data from Qvds

alexandros17 — Mon, 14 Jul 2014 12:10:54 GMT

Load

...

from ....

Where ....;

let me know

Re: Where condition while fetching data from Qvds

ashfaq_haseeb — Mon, 14 Jul 2014 12:11:44 GMT

Hi possible.

look at below code

Dept:

LOAD empid,

deptname

FROM

dept.qvd

(qvd) where deptname = 103 ;

Regards

ASHFAQ

Re: Where condition while fetching data from Qvds

Anonymous — Mon, 14 Jul 2014 12:30:55 GMT

Try like this:

Dept:

LOAD empid,

empname,

salary,

deptname

FROM

dept.qvd

(qvd) where Salary > = 30000 ;

Re: Where condition while fetching data from Qvds

its_anandrjs — Mon, 14 Jul 2014 12:39:00 GMT

Yes you may and there are many ways for that depends on the condition that you have

Ex:-

Load

CommonDate,

Name,

Country

From QVD

Where CommonDate = Today();

Load

CommonDate,

Name,

Country

From QVD

Where Rowno() > 50;