Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

10 Replies
sushil353
Master II
Master II

Not applicable

Thanks works fine for me !!

rajni_batra
Specialist
Specialist

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 ?

tresesco
MVP
MVP

PFA. Hope this helps.

Thanks.

rajni_batra
Specialist
Specialist

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

tresesco
MVP
MVP

PFA

rajni_batra
Specialist
Specialist

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

tresesco
MVP
MVP

Did you check app 2?

roll2.PNG

rajni_batra
Specialist
Specialist

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