topic Re: How to convert SQL crystal query into Qlikview in QlikView

How to convert SQL crystal query into Qlikview

varaprasad0816 — Sat, 16 Nov 2024 01:48:36 GMT

Ho to convert below SQL crystal query into Qlikview Data Model.

FROM (((((("Sabre GLBL Inc"."Sabre GLBL Inc.User" "User_CaseOwner"
INNER JOIN
"Sabre GLBL Inc"."Sabre GLBL Inc.Case" "Case"
ON "User_CaseOwner.Id"="Case.OwnerId")

Regards,

Vara

Re: How to convert SQL crystal query into Qlikview

varaprasad0816 — Mon, 02 Dec 2019 12:34:58 GMT

Below script is actual script.

Ho to convert below SQL crystal query into Qlikview Data Model.

FROM (((((("Sabre GLBL Inc". "Sabre GLBL Inc". "User" "User_CaseOwner"
INNER JOIN
"Sabre GLBL Inc". "Sabre GLBL Inc". "Case" "Case"
ON "User_CaseOwner.Id"="Case.OwnerId")

Regards,

Vara

Re: How to convert SQL crystal query into Qlikview

Brett_Bleess — Wed, 11 Dec 2019 13:44:41 GMT

Vara, there is no need to convert things, simply use the DSN you have for the DB and use the Connect function in our load script to make the DB connection and then use the Select function to make your selections etc.

Here are some Help links with further details:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Edit_Script_dialog_box.htm

Actually, just this one link puts you in the place where you can get all the info regarding how to setup things from what I can see... Shout if you have further questions.

Here is a Design Blog post on Data Modeling as well that may be of some further help:

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Modelling-Clarity-vs-Speed/ba-p/1473644

Regards,
Brett