topic Re: Coverting PL/SQL into qlikview syntax in QlikView

Coverting PL/SQL into qlikview syntax

Tue, 23 Oct 2012 08:30:31 GMT

Hi Guys,

Am new to qlikview and i have been working on oracle, can some one help me convert the following code to qlikview syntax.

CASE WHEN "GENPOLICY"."POL_CANCEL_CDE" IS NULL THEN "MDRCANCELREF"."MDRCANCELREF_KEY"

ELSE "GENPOLICY"."POL_CANCEL_CDE"

END As "Cancel Code",

FROM "INSIGHT"."GENPOLICY" "GENPOLICY"

INNER JOIN "INSIGHT"."MDR_POLICY" "MDR_POLICY"

ON "GENPOLICY"."POLICY_KEY"="MDR_POLICY"."MDR_POLICY_KEY")

LEFT OUTER JOIN "INSIGHT"."MDRCANCELREF" "MDRCANCELREF"

ON "GENPOLICY"."POL_CANCEL_CDE"="MDRCANCELREF"."MDRCANCELREF_KEY")

Tue, 23 Oct 2012 09:47:12 GMT

hi you can directly use Sql Statments in QlikView

TableName:

load * ( or fieldnames)

SQL your Select query

Hope it will help

Regards

- Anil

MayilVahanan — Tue, 23 Oct 2012 10:00:52 GMT

if you need to store into qvd file instead of performancc issues, try lik this

Table1:

Load *;

sql select your query;

store table into filename.qvd(qvd);

After that you can use qvd file..

Hope it helps

Tue, 23 Oct 2012 10:22:42 GMT

Hi,

would it make any difference perfoemance wise if i converted the sql into IF statements using flags?

Tue, 23 Oct 2012 10:26:54 GMT

hi Brytesikaz,

Its depends on the data set, If can reduce the performance with large data set.

Regards

- Anil

MayilVahanan — Tue, 23 Oct 2012 10:48:27 GMT

please read this for performance

this thread contains lot of information n nice.