Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Problem with in data giving wrong numbers?

Hi All,

I have a data set where i need to perform few calculations.

Due to replicates in data set i am getting wrong numbers for calculations.

Please find attached file which has sample data and please help me to resolve the issue.

Thanks

1 Reply
Highlighted
MVP
MVP

Re: Problem with in data giving wrong numbers?

What combination of dimensions would describe the unique paid amount? ID and Num?

Then maybe try

ID sum([Paid Amount]) =Sum(Aggr([Paid Amount], ID,Num))
600200 300100
BBB600200300100

But maybe it's better to remodel your data, so that facts don't get duplicated.