Discussion Board for collaboration on QlikView Layout & Visualizations.
I have an Oracle function that returns if a policy has been changed or not.
How can I addopt this function to qlikview?
each information helps me...
FUNCTION IS_ANNEX_CHANGED (p_policy_id number) return varchar is
cursor c1 is select count(*)
from gen_risk_covered grc, cfg_gl_gen_fractions cfg
and risk_state between 0 and 12
--and risk_state between 0 and 12
fetch c1 into nr;
if nvl(nr,0)>0 then
else return 'N';
I would want to be able to identify a primary key - e.g. a Policy number. Then I could write something like:
policy_id as PolicyID;
SQL select policy_id
policy_id as PolicyID2
Where Exists (PoilicyID1, policy_id);
Then, if you have anything in the PolicyID2 field (use FieldValueCount), you know the policy number.
Or something like that ;-)