topic can anyone suggest ?? in QlikView

can anyone suggest ??

suvechha_b — Wed, 31 Jul 2013 09:16:40 GMT

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 — Wed, 31 Jul 2013 10:25:06 GMT

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 — Fri, 19 Aug 2016 10:56:40 GMT

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