Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

isadoralmeida06
New Contributor III

É possível fazer queries SQL no QVD?

Olá,

com um qvd já criado é possivel fazer queries? Por exemplo, select * from qvd_table;

 

Obrigada

1 Solution

Accepted Solutions
Partner
Partner

Re: É possível fazer queries SQL no QVD?

SQl will not work.
When loading from QVD
LOAD *
FROM YOURPATH\QVD\FACT.qvd (QVD);
8 Replies
Partner
Partner

Re: É possível fazer queries SQL no QVD?

Yes
isadoralmeida06
New Contributor III

Re: É possível fazer queries SQL no QVD?

Hi, so I tried doing it, but it gives me an error. It doesn't recognize the SQL statement (select * from qvd_name);

Could you please send me a QVW with an example?

 

Thank you,

Partner
Partner

Re: É possível fazer queries SQL no QVD?

SQl will not work.
When loading from QVD
LOAD *
FROM YOURPATH\QVD\FACT.qvd (QVD);
Partner
Partner

Re: É possível fazer queries SQL no QVD?

Highlighted
isadoralmeida06
New Contributor III

Re: É possível fazer queries SQL no QVD?

Thanks! That's all I needed to know if Qlik View would accept SQL queries just to fetch some data for quick analyses.

 

Partner
Partner

Re: É possível fazer queries SQL no QVD?

Qlik will accept SQL when accessing database.
isadoralmeida06
New Contributor III

Re: É possível fazer queries SQL no QVD?

Ok, gotcha! But my manager wanted to  do queries on the QVD I`ve being generating, but he only knows sql, not qlik syntax. 

Partner
Partner

Re: É possível fazer queries SQL no QVD?

You should read up the usefulness of qvds .
Few of which are incremental loads, less strain on db etc