topic Re: Show last 13 months as a calculated dimension in QlikView

Show last 13 months as a calculated dimension

hmjason7 — Tue, 18 Nov 2014 17:41:46 GMT

Hello,

I am trying to show just the last 13 months as a calculated dimension in a Month-Year format for a chart, but it doesn't seem to work.

My MonthYear field is created by the following expression:

Date(MakeDate(Year(MyDateField), Month(MyDateField),1), 'MMM-YY') as MonthYear

Do I create the expression as a calculated dimension or should it be done as a set analysis expression?

If so, what expression should I use?

Cheers,

Jason

Tue, 18 Nov 2014 18:08:28 GMT

Jason,

I would create the Attribute for Month year in script:

Date(Date#(MyDateFeild,'MMM-YY) ,'MMM-YY') as MonthYear

Then limit data in set analysis expression

Here is qvw to show example

hmjason7 — Wed, 19 Nov 2014 10:35:45 GMT

Thanks Shawn - works like a charm.