Problem in adding duplicated data in computation

Wed, 02 Dec 2015 00:50:25 GMT

I have a problem in my data and still I cant get over it. Heres my data;

yr(Effectivity year)

year(year of payment)

PIN OwnerNum owner year yr ToTalTax

pin123 1000 data1 2015 2016 1,000

pin123 1000 data1 2015 2014 1,100

pin123 1000 data1 2015 2013 900

pin456 1000 data2 2015 2009 2,000

pin456 1000 data2 2015 2008 1,000

TotalTax is computed using this expression;

sum({<year1= {"2015"},PayPenalty={"<=0"}>} aggr(DISTINCT PayBasic,year1,OwnerNum,BINum,PCINum,SINum,MDINum,Parcel,PType)) 
+ sum({<year1= {"2015"},PayPenalty={"<=0"}>} aggr(DISTINCT PaySEF,year1,OwnerNum,BINum,PCINum,SINum,MDINum,Parcel,PType)) 
- sum({<year1= {"2015"},PayPenalty={"<=0"}>} aggr(DISTINCT PayDiscount,year1,OwnerNum,BINum,PCINum,SINum,MDINum,Parcel,PType))

PIN is compose of (BINum,PCINum,SINum,MDINum,Parcel,PType)

What I want is to compute the first data whose effectivity year <=2015. I want to display this data on my straight table and Bar graph.

;

PIN OwnerNum owner year yr ToTalTax

pin123 1000 data1 2015 2014 1,100

pin456 1000 data2 2015 2009 2,000

See Data Model in my attachment..

Re: Problem in adding duplicated data in computation

marcus_sommer — Wed, 02 Dec 2015 01:57:46 GMT

I think you will need at first to rethink your datamodel and adjust the associations between the tables then there are a lot of synthetic keys. Have a special look on the first three links in Get started with developing qlik datamodels.

- Marcus

topic Problem in adding duplicated data in computation in QlikView

Problem in adding duplicated data in computation

Re: Problem in adding duplicated data in computation