can anyone suggest ??

[suvechha_b]

How to write this in expression of qlikview??

sum({< [Fiscal Month],[Fiscal Year]={"<=$(vMinYear)">} [fiscal_key] = {"<= $(vMinPeriod)"} >}[Ledger Amount])

I want to sum [Ledger Amount] where [Fiscal Month],{<[Fiscal Year]={$(vMinYear)}>} and also fiscal_key condition should be there??

[suvechha_b]

Can you help me out in calculating :

sum(Ledger Amount) of previous year..

like :

2013Jan  :100 

2013Feb :200

2013 Mar:300

if I select Mar2013:

it should give :600

and if I select Feb2013 : 300

but the total should be for jan,feb and Mar = 600

[subathra]

RangeSum( Above( sum({<Month={'>=$(=yearstart(max(Month)))<=$(=max(Month))'}>}linesalesamount) , 0 , rowno()) )