# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Creator II

## Showing previous 12 months data in graph on single selection in Month Filter

Hi,

We have a requirement in Qliksense where on selection of any month in month filter it should show previous 12 months data in the graph

for example if we select Jul 2017 it should show from Jul 2016 to  Jul 2017 as shown below

Needed help to acheive this requirement

Regards,

Bhargav

1 Solution

Accepted Solutions

Is there any challenge you faced using?

Sum({<MonthYear = {">=\$(=AddYears(Max(MonthYear), -1)) <=\$(=Max(MonthYear))"}>} Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
8 Replies

Is there any challenge you faced using?

Sum({<MonthYear = {">=\$(=AddYears(Max(MonthYear), -1)) <=\$(=Max(MonthYear))"}>} Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

He might have to make sure that the formatting within the set analysis is right and also make sure to not have spaces between ranges....So what I mean is this

Have this

>=blahblah<=blahblah

>=blahblah <=blahblah

Master II

is there no need of changing to 'MMM YYYY'  format?

Learning never stops.
Creator II
Author

Hi Anil,

As per requirement,we do  not  have to sum up the 12 months data . we just need to have data in graph for previous 12 months in graph.The issue is that on selection of a month in month filter it shows data for single month only in graph

Regards,

Bhargav

May be Only() helps here

Update - As suggest by sunny

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

When you say Month is it the same field as your dimension? which include Month and Year or is this a separate field from MonthYear? Can you share the name of your fields? and the expression you are using right now?

I believe, He can manage with Format or he will surf in google

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Author

Hi Sunny,