Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

incremetal load in qlikview

        Dear folks,

Find my requirement and provide me a better solution

SOURCE_PRODUCT_METRICS_AIDACCOUNT_IDPRODUCT_CATALOG_IDPRODUCT_METRICS_DIMENSION_IDSTART_DATE_IDEND_DATE_IDSTART_DATEEND_DATEACTIVE_INDCOUNTRY_IDPREV_FORMULARY_STATUSCURR_FORMULARY_STATUSCluster
sp1ac1pc1pm1a1b11/10/201615/10/2016167NullIn ProgressNeutral
sp2ac2pc2pm2c1d11/11/201615/11/2016167NullRestrictedNeutral

sp3

the above data is loading first time from data base

and the below data is been changed in next day along with old records

so now i want to find the logic which is how many records been changed and how many are new and how many not been changed

ac3pc3pm3c3d323/11/20161/1/9999167NullRegional CommitteeNeutral
SOURCE_PRODUCT_METRICS_AIDACCOUNT_IDPRODUCT_CATALOG_IDPRODUCT_METRICS_DIMENSION_IDSTART_DATE_IDEND_DATE_IDSTART_DATEEND_DATEACTIVE_INDCOUNTRY_IDPREV_FORMULARY_STATUSCURR_FORMULARY_STATUS
sp1ac1pc1pm1a1b11/10/201615/10/2016167NullIn Progress+
sp1ac1pc1pm1a2b216/10/201631/10/2016167In ProgressApprovedactive
sp2ac2pc2pm2c1d11/11/201615/11/2016167NullRestricted-
sp2ac2pc2pm2c2d216/11/201623/11/2016167RestrictedRejectedactive
sp3ac3pc3pm3c3d323/11/20161/1/9999167NullRegional Committeenc neutral
sp4ac4pc4pm4c4d423/11/20161/1/9999167NullRejectednew-
sp5ac5pc5pm5c5d523/11/20161/1/9999167NullUnrestrictednew+
sp6ac6pc6pm6c6d623/11/20161/1/9999167NullNot Appicablenew neutral
cluster change indicatornew/nochange/+/-
Idcount
Positive Change 1,70+1+0+1=2
sp1, sp5
Neutral Change 81
sp6
Negative Change3,60+0+1+1=2
sp2, sp4
0 Replies