Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

adoteykwame
Contributor

Sum only latest value

Hi!

Polices may have multiple transactions, I would want to sum amounts for only the latest transactions assuming the date keeps updating each time but the amount field keeps several layers. So for instance when i click on a policy it displays only the latest date but several occurences of the amount which when summed gives undesirable result.

Kwame

Thanks

2 Replies
sushil353
Honored Contributor II

Re: Sum only latest value

could you have any sample application or data..

or else try to use the firstsortedvalue function.

HTH

Sushil

adoteykwame
Contributor

Re: Sum only latest value

firstsortervalue.PNG

I could only attach this and all I wanted is to sum only the most recent value in the m_Sum Assured.

Kwame

Community Browser