topic Re: Select query on QVD in QlikView

Select query on QVD

Tue, 23 Apr 2013 11:51:08 GMT

hi all,

can we have a select query on a QVD.

like first load the qvd

load * from qvd and then

select few columns from qvd

is it possible

thanks

nilesh_gangurde — Tue, 23 Apr 2013 11:57:11 GMT

if you want few columns from qvd, instead of using "Load * from Qvd"

use the "Load (Column names) from Qvd".

-Nilesh

kaushiknsolanki — Tue, 23 Apr 2013 12:03:08 GMT

Hi,

You can not use the Select query when getting data from QVD, it is used only when you are fetching data from Databases like Oracle, mysql and so on.

But yes you can filter the data based on some condition like you do in Select Query when you are fetching data from QVD;

Regards,

Kaushik Solanki

Tue, 23 Apr 2013 12:07:18 GMT

Thanks Kaushik.

Can we use Sum function along with if statement while loading data from QVD??

kaushiknsolanki — Tue, 23 Apr 2013 12:10:10 GMT

Hi,

Yes you can do. Something like this.

Load if(Country = 'INDIA', sum(Amount)) as INDIA_SALES

From XYZ;

Regards,

Kaushik Solanki

er_mohit — Tue, 23 Apr 2013 12:37:03 GMT

try this.Suppose in A table ur column is a to z which is fetch from qvd.......

load * from qvd;

load a,b,c

resident A ;

drop table A;