Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select query on QVD

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

5 Replies
nilesh_gangurde
Partner
Partner

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

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

-Nilesh

kaushiknsolanki
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

Thanks Kaushik.

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

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Yes you can do. Something like this.

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

     From XYZ;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
er_mohit
Master II
Master II

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

A:

load * from qvd;

B:

load a,b,c

resident A ;

drop table A;