Sum of Stock value of last five quarter . Help me please ?

[prahlad_infy]

Hello Sir ,

Helping me on dynamically finding Sum of Stock value of ONGOING quarter and last five quarter .

smething like below only

THANK YOU

[prahlad_infy]

neelamsaroha1575‌ .. Help me please .

[qlikviewwizard]

Can you attach sample in text file

[prahlad_infy]

Do you mean sample data in text file ?

I wanting a set expression which should show me data for current quarter and last 5 quarter .

[shekhar_analyti · Accepted solution]

Invariable overview

vToday=Today()

vL15m=AddMonths(Max(Date(Today())),-15)

Chart Type : Pivot

Dimension : STOCK , Yearqtr

Expression :SUM({$<DATE={">=$(=Date(vL15m))<=$(=Date(vToday))"} >} money)

[shekhar_analyti]

small correction :

vL15m=MonthStart(AddMonths(Max(Date(Today())),-15))

[prahlad_infy]

Thank You Sir . It is working .

But i do not seeing any difference between results of
AddMonths(Max(Date(Today())),-15)

MonthStart(AddMonths(Max(Date(Today())),-15))

Explain it to me .