Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
egemenekinci
New Contributor III

Left Join Duplication and Storing different tables

Dear experts,

I need a solution about for my issue. I have joined two tables with below script but since PaidDate field record in joined table has 2 different records it makes duplication of Premium field after join. I would exclude Paid Date and get sum of claim amount and solve this problem but. I might use paid date field in other tables.

So how can pass a zero value for the duplicated premium field like writing in a condition if claimsID are same for the previous column value of premium field of this record should be zero ?

Or as a second solution can I keep  the table with paid date field as a separate table in my data ?

PolicyData:

LOAD Policy,

     Type,

     Premium

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join (PolicyData)

LOAD Policy,

        ClaimID,

     [Claim Amount],

     [Paid Date]

FROM

(ooxml, embedded labels, table is Sheet2);

I have attached a sample app for your reference.

Your help will be appreciated.