topic sum for maximum date issue in QlikView

sum for maximum date issue

sudeep_d — Tue, 26 Feb 2013 12:44:17 GMT

contract yrmnth amt

123 201209 100

123 201208 200

123 201207 300

543 201206 400

543 201206 500

543 201205 600

Given the above table...

contract amt

123 100

543 900

required the above table..

here amt for max date for each contract is required..

I require the calculation in expression not in calculated dimension

Any help would be appereciated.

Thanks

nagaiank — Tue, 26 Feb 2013 12:54:40 GMT

If contract is the dimension, the following expression will give what you need.

FirstSortedValue(amt,-yrmnth)

Hope this helps.

muniyandi — Mon, 04 Mar 2013 12:14:56 GMT

Hi sudeep,

just write expression on

sum(if(yrmnth=Aggr(nodistinct max(yrmnth),contract),amt,0))

Hope this helps you

Regards,

Muni