Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Previous Data?

Hi All ,

i m facing one issue Showing Data From Apr_2012 to Sep_2015.

I Have >Financial Year :2010-2011 to 2015-2016.

I have MonthYear Format MM YYYY.

If i take Left( MonthYear ,3) &' '& Right(FinancialYear,2) as Caluculated Dim Its Not Working

7 Replies
subbareddykm
Creator II
Creator II
Author

Can any one tell me how to do this?

sunny_talwar

Can you may be provide some sample data?

Mark_Little
Luminary
Luminary

Hi,

Can you supply some more information.

From the details provided i am not sure what you are trying to achieve. Is it possible to supply some sample data or Qvw?

Mark

santhosh_k_n
Creator II
Creator II

Hi,

try using, month(monthyear,MMM)&year(financialyear,yy)

BR

SK

Anonymous
Not applicable

sample data?

subbareddykm
Creator II
Creator II
Author

!

subbareddykm
Creator II
Creator II
Author

Hi Sunny,

That is my Sample data in that ,i want to show Data from 2012-2013 to 2015-2016.Means Apr-13 to Sep-16.

I want dynamically like if i see next month next Apr-13 to Oct-16.

Change the expression if require for Sales And Growth

Regards,

SRK