topic Re: AddMonths function in QlikView

AddMonths function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a start date 02/15/2017. I need to add number of months to get the end date. Suppose no of months=12 will give me the end date 02/15/2018. The number of months will come from a field. I know the function AddMonths but it's only working when I am giving the number of months explicitly.

AddMonths(date(Subscription_Start_Date__c),12) is working.

But how do I write the function if the number of months is coming from another field?

AddMonths(date(Subscription_Start_Date__c),Subscription_Duration) doesn't work.

Thanks!

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:06:13 GMT

Where is this used? May be this:

AddMonths(Date(Subscription_Start_Date__c), Max(Subscription_Duration))

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:09:51 GMT

In the script. Gives an error saying invalid expression.

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:12:05 GMT

I don't see why your original expression won't work in the script. Do you have Subscription_Start_Date__c and Subscription_Duration in one table when you are doing this AddMonths calculation???

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:18:43 GMT

Yes.

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:23:36 GMT

How about this?

AddMonths(Date#(Subscription_Start_Date__c, 'MM/DD/YYYY'), Subscription_Duration__c)

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:32:47 GMT

Not working

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:36:15 GMT

Why don't you paste the screenshot of the error you have received

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:44:11 GMT

Writing the max function is giving error while reloading the script 'Invalid expression'. Omitting the max function, the field 'test' is not displaying any values.

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:47:52 GMT

‌can you run your script without this and send a screenshot for the Subscription_Start_Date__c field.... seems like QlikView doesn't interpret as a date field.

Best,

Sunny

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:52:23 GMT

I am using the Date function to convert it.

Re: AddMonths function

sunny_talwar — Mon, 30 Jan 2017 23:54:47 GMT

I don't understand.... this should work

Date(AddMonths(Subscription_Start_Date__c, Subscription_Duration__c)) as test

Re: AddMonths function

Anonymous — Mon, 30 Jan 2017 23:59:23 GMT

Doesn't work

Re: AddMonths function

sunny_talwar — Tue, 31 Jan 2017 00:01:28 GMT

Is Subscription_Duration__c a number field is the last thing I can ask you to check.... otherwise I have no idea... Unless you are able to share a sample, I have no idea why it isn't working

Date(AddMonths(Subscription_Start_Date__c, (Subscription_Duration__c * 1))) as test

Re: AddMonths function

Anonymous — Tue, 31 Jan 2017 20:54:21 GMT

num# worked

Re: AddMonths function

martinscottquinn — Mon, 06 Jul 2020 16:33:30 GMT

You are trying to use a field (with the __C) that's been renamed. Try using [Subscription Start Date] instead in your AddMonths statement.