Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Rolling 6 Months based on Month Selected

Hi Dear QV Community

I have the "Rolling6Months.qvw" with a table info i need sum the last six months based on month selected.

Example: If I Select Nov 2012 The Second Expresion of Pivot table and TextObject make a sum of sales from Jun2012 to Nov 2012

Regular Expression: =Sum({<DescTarifa=>} [Vta Neta])

Please download the QVW attachement

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Rolling 6 Months based on Month Selected

Hi,

PFA

HTH

Sushil

10 Replies
sushil353
Honored Contributor II

Re: Rolling 6 Months based on Month Selected

Hi,

PFA

HTH

Sushil

Not applicable

Re: Rolling 6 Months based on Month Selected

Thanks works fine for me !!

rajni_batra
Valued Contributor

Re: Rolling 6 Months based on Month Selected

Hii ,

i also have similar kind of requirement, i want 6 month rolling on MOM basis,

If i am selecting Nov it should show data of past 6 months which is already done in ur sample app but if i diaplay it on month basis it displays past 6 months also but here i want single month NOV displays data for 6 months , is this possible ?

MVP
MVP

Re: Rolling 6 Months based on Month Selected

PFA. Hope this helps.

Thanks.

rajni_batra
Valued Contributor

Re: Rolling 6 Months based on Month Selected

as in 2nd expression in table 645 is sum of last six mnths , same output i want in MoM i.e. on selction of DEC 13 it should give 645 in chart also but on x axis it should show only dec not all last 6 months.

Hope it clear my requirement

MVP
MVP

Re: Rolling 6 Months based on Month Selected

PFA

rajni_batra
Valued Contributor

Re: Rolling 6 Months based on Month Selected

No , I want single bar showing sum of all 5, please see the screenshot attached

MVP
MVP

Re: Rolling 6 Months based on Month Selected

Did you check app 2?

roll2.PNG

rajni_batra
Valued Contributor

Re: Rolling 6 Months based on Month Selected

Yes, i have sent scrrenshot from app 2 itself, Please send if there is any updated version.

Community Browser