Coverting PL/SQL into qlikview syntax

[#1]

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")

[#2]

hi you can directly use Sql Statments in QlikView

TableName:

load * ( or fieldnames)

SQL your Select query

Hope it will help

Regards

- Anil

[MayilVahanan]

  hi

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

[#4]

Hi,

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

[#5]

hi Brytesikaz,

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

Regards

- Anil

[MayilVahanan]

Hi

please read this for performance

http://community.qlik.com/thread/18473?start=0&tstart=0

this thread contains lot of information n nice.