
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add Months to a dimension
Dear Qlikview user
I have a field called Month which I would like to use as the dimension in my chart
My data set spans from May-15 - Sep 16
I would like to place set analysis on my Month dimension so that the dimension only shows the from May-16
Currently I have Month added as a dimension and in the Enable Conditional I have the following
AddMonths($(Min_Start_Date),12)
The Min_Start_Date is the minimum date in the data set
Can anyone help me try to achieve my requirement

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Helen,
Have you tried this expression in a calculated dimension instead of a conditional show ?
So, instead of using 'Month' as a dimension, try using 'AddMonths($(Min_Start_Date),12)' as a calculated dimension.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are using the above expression in the Enable condition. This is not where you would want to use this. Try may be using a calculated dimension (this would replace your Month)
If(AddMonths(Min(TOTAL DateField), 1) >= DateField, DateField)
and then select 'Suppress When Value Is Null' on the dimension tab

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
should you want to try this without using a calculated dimension (purely for performance gains should it be slow) you could put it inside set analysis as follows
sum({<MyDate={'>=$(vMyDate)'}>}MyColumn)
vMyDate will contain the date you want to show from and in your case is the result of AddMonths($(Min_Start_Date),12).
you will need to put in all your expressions to limit them all.
