topic Re: Sum of Stock value of last five quarter . Help me please ? in QlikView

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

prahlad_infy — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 03 Oct 2018 11:59:30 GMT

neelamsaroha1575‌ .. Help me please .

qlikviewwizard — Wed, 03 Oct 2018 12:03:10 GMT

Can you attach sample in text file

prahlad_infy — Wed, 03 Oct 2018 12:06:25 GMT

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 — Wed, 03 Oct 2018 13:05:22 GMT

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 — Wed, 03 Oct 2018 13:10:54 GMT

small correction :

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

prahlad_infy — Wed, 03 Oct 2018 13:24:15 GMT

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 .