topic Re: How to perform SQL query on QVD in QlikView

How to perform SQL query on QVD

Jacob — Sat, 16 Nov 2024 03:52:46 GMT

Hi all,

I want to perform sql query on qvd file .how can i do it

Anyone can help

Below is SQL query:

CREATE OR REPLACE VIEW pushed (country,anx_count )
AS
SELECT SUBSTR(t1.name,0,2) AS country,
  COUNT(SUBSTR(t1.name,0,2)) anx_count 
FROM t_table2 t2,
  t_table1 t1
WHERE t2.date BETWEEN add_months(trunc(sysdate,'mon'),-1) AND trunc(sysdate,'mon')-(1/86400)
AND t2.bname_id = t1.name_log_id
GROUP BY SUBSTR(t1.name,0,2)

Note

I dont have SQL Connection I am working on QVD.

Re: How to perform SQL query on QVD

dapostolopoylos — Fri, 12 Apr 2019 08:50:40 GMT

You cannot manipulate a qvd file with SQL...
The only way is to use a Load statement.

Re: How to perform SQL query on QVD

Wilson_Webb — Fri, 12 Apr 2019 10:26:09 GMT

You cannot use SQL syntax to load a QVD. The best way I can think around this for you to script in sql and store into a qvd. This way the QVD has all the necessary transformations you needed.

Let us know if this makes sense.