topic Re: Add Months to a dimension in QlikView

Add Months to a dimension

helen_pip — Wed, 14 Sep 2016 14:48:47 GMT

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

Re: Add Months to a dimension

Anonymous — Wed, 14 Sep 2016 14:52:57 GMT

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.

Re: Add Months to a dimension

sunny_talwar — Wed, 14 Sep 2016 14:53:16 GMT

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

Re: Add Months to a dimension

tracysmart — Wed, 14 Sep 2016 15:06:22 GMT

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.