topic Re: How force function AddMonths work? in QlikView

How force function AddMonths work?

Wed, 25 Jun 2014 11:28:05 GMT

Hi to all!

I have field with Date, and in SET ANALYSIS i need Date bigger at 1 month.

But AddMonths Does not work...

Look in attach.

Re: How force function AddMonths work?

Gysbert_Wassenaar — Wed, 25 Jun 2014 11:42:20 GMT

In a text box you can use =AddMonths(CurrDate,1) if you first select one value in the field CurrDate.

Re: How force function AddMonths work?

Wed, 25 Jun 2014 11:45:49 GMT

Do not use Dollar expansion in text object, use it Like =Addmonths(CurrDate,1)

Re: How force function AddMonths work?

Wed, 25 Jun 2014 11:49:17 GMT

yes, i know.

but i use AddMonths in SET ANALYSIS, and there $(=AddMonths(CurrDate,1)) does not work, because this function doesn't result a date.

and a textboxes i add for clarity.

Re: How force function AddMonths work?

Wed, 25 Jun 2014 11:50:01 GMT

yes, look my answer above

Re: How force function AddMonths work?

Wed, 25 Jun 2014 11:56:31 GMT

Привет!

CurrDate - это поле, Set Analysis не принимает поле, как правую часть условия, ему нужно конкретное значение. Попробуй использовать функцию p():

$(=AddMonths(p(CurrDate),1))

Re: Re: How force function AddMonths work?

Gysbert_Wassenaar — Wed, 25 Jun 2014 11:58:31 GMT

Because your field CurrDate doesn't contain any value that's exactly a month later than another value. If you add such a value you can see that addmonths does work. See attached qvw.

Re: How force function AddMonths work?

Wed, 25 Jun 2014 11:59:40 GMT

use dis in set CurrDate ={'$(=AddMonths(CurrDate,1))'}

Re: How force function AddMonths work?

Wed, 25 Jun 2014 12:05:49 GMT

Он прекрасно принимает поля. когда в них выбрано одно значение. Если не выбрано ничего или выбрано несколько то конечно ничего работать не будет.

Re: How force function AddMonths work?

Wed, 25 Jun 2014 12:08:28 GMT

Thank You, i just forgot to put quotes in textbox

If in TX08 put text "='$(=AddMonths(CurrDate,1))'" - all works perfectly!