topic Re: Previous Data? in QlikView

Previous Data?

subbareddykm — Tue, 24 Nov 2015 09:17:21 GMT

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

subbareddykm — Tue, 24 Nov 2015 09:28:41 GMT

Can any one tell me how to do this?

sunny_talwar — Tue, 24 Nov 2015 13:25:50 GMT

Can you may be provide some sample data?

Mark_Little — Tue, 24 Nov 2015 13:26:26 GMT

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 — Tue, 24 Nov 2015 13:26:32 GMT

Hi,

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

Anonymous — Tue, 24 Nov 2015 13:26:40 GMT

sample data?

subbareddykm — Tue, 24 Nov 2015 14:20:15 GMT

subbareddykm — Tue, 24 Nov 2015 14:25:56 GMT

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