Discussion Board for collaboration related to QlikView App Development.
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
if you want few columns from qvd, instead of using "Load * from Qvd"
use the "Load (Column names) from Qvd".
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;
Can we use Sum function along with if statement while loading data from QVD??
Yes you can do. Something like this.
Load if(Country = 'INDIA', sum(Amount)) as INDIA_SALES
try this.Suppose in A table ur column is a to z which is fetch from qvd.......
load * from qvd;
resident A ;
drop table A;