Below is the SQL script which I am using in Qlikview script editor. I have extracted the data using SQL query in Tier 1 and loaded the QVD in tier 2 to make application but now I want the script to be in Qlikview code only.
Please help me build it. Also, I have additional requirement -- If I load 4 PROC_CYC_ID :: 66,69,72,75 then on front end when I select 75 the below code should comapre the data (means Policies) with 72 PROC_CYC_ID. Similarly, 72 to be comapred with 69, 69 to be comapred with 66 likewise.