topic "Translation of SQL code to QV in QlikView

"Translation of SQL code to QV

fabricius — Mon, 27 Nov 2017 10:43:53 GMT

Can anyone "translate" this SQL code for me into something that I can use in Qlikview?

select distinct WEXAM_ID, WEXAM_ID_STRING, WEXAM_DATE from W_EXAM

left join W_EXAM_FOLDER on WEXAM_ID = WEF_EXAM_ID

left join W_IMAGE_FOLDER on WEF_ID = WIF_EF_ID

where WEF_ID is not null and WIF_ID is null and WEXAM_DATE between '2017-10-01' and '2017-10-31'

group by WEXAM_ID, WEXAM_ID_STRING, WEXAM_DATE, WEF_BF_ID

order by WEXAM_ID_STRING;

Re: "Translation of SQL code to QV

woshua5550 — Mon, 27 Nov 2017 11:01:57 GMT

why you have to do this ? what is your data source ?

Re: "Translation of SQL code to QV

shraddha_g — Mon, 27 Nov 2017 11:03:32 GMT

you can direcly use this query in qlik

Re: "Translation of SQL code to QV

jonathandienst — Mon, 27 Nov 2017 11:20:15 GMT

>>something that I can use in Qlikview

That's a little vague. Anyway, it is not necessary to translate the SQL. The SQL query is executed on the database server, not in QV, so you can add the query as-is to your load script with a CONNECT call and your SQL code with a SQL prefix:

CONNECT ....;

TableName:

SQL

SELECT ....;

If you have a reason for "translating" into QV, perhaps you could be a lot more specific about your requirement.