topic Re: Dynamic Date as Dimension in QlikView

Dynamic Date as Dimension

Wed, 02 Sep 2015 20:01:36 GMT

Hey guys!

I need to create a Pivot which has three months as a Dimension. These months are based on the "Year" and "Month" fields selections, such as it shows the selected months and the two previous months. Therefore, if the user selects "2015" and "September", for example, I want my chart to show "September", "August" and "July" as it's dimension (all of them related to 2015, of course).

My database has data related to every month of the past five years and, therefore, I can't use the "Month" field as my dimension. Any ideas on how can I do this?

P.S.: I NEED the months to be my dimension due to some database particularities. They cannot be my expressions.

Thanks a lot!

Re: Dynamic Date as Dimension

rwunderlich — Wed, 02 Sep 2015 21:23:11 GMT

You should create a YearMonth field in your data model, even if you don't use it for display.

MakeDate(Year, Month) as YearMonth

Then you can use that field in Set modifiers, in either Dimensions or Expressions, to limit you display to max(YearMonth)-2.

-Rob

Re: Dynamic Date as Dimension

MarcoWedel — Wed, 02 Sep 2015 22:04:33 GMT

please post sample data to demonstrate.

regards

Marco

Re: Dynamic Date as Dimension

Thu, 03 Sep 2015 14:55:39 GMT

Thanks for the response Rob!

I came up with the YearMonth field, but I don't know how to set this dimension limit. I tried "Show only" largest 3 and first 3. But it only shows the YearMonth selected.

How do I do this?