topic AddMonths in set analysis? in QlikView

AddMonths in set analysis?

Thu, 08 Oct 2009 14:34:17 GMT

Hi,

Is it possible to use Addmonths in set analysis?

I want to rewrite this:

sum

({$ <BETBOKFD_IN = {">2008-06-30"}> }_ForsCounter)

With something like this:

sum

({$ <BETBOKFD_IN = {">=$(AddMonths(AVSERPERIOD,-15)"}> }_ForsCounter)

Is it possible and how do I write it (as the above code dosen't work)?

AddMonths in set analysis?

Thu, 08 Oct 2009 14:37:46 GMT

Hi,

see the attached example.

God luck!

Rainer

AddMonths in set analysis?

Thu, 08 Oct 2009 15:57:12 GMT

Thanks,

Now I can copy your syntax, I still doesn't work for me though. I'll have another try at it later.
I'll let you know.

Regards,
Christina

AddMonths in set analysis?

Thu, 08 Oct 2009 16:01:42 GMT

Christina,

be aware of the date format. That´s number one of most of the problems by using "Set Analysis".

Rainer

AddMonths in set analysis?

Thu, 08 Oct 2009 17:43:16 GMT

Hi again,

I've tried Rainer's soloution, but apparently I'm doing something wrong as his set analysis is working.
Therefore I attached my example.

All suggestions are welcome.

By the way my version is 8.5

Regards,

Christina

AddMonths in set analysis?

Anonymous — Thu, 08 Oct 2009 21:12:15 GMT

Hi,

Try this.....

sum

({<BETBOKF_IN = {"<=$(=date(max(addmonths(AVSERPERIOD,-15))))>=$(=date(max(addmonths(AVSERPERIOD,0)))))"}>} _ForsCounter)

Cheers.

Ad.

AddMonths in set analysis?

Fri, 09 Oct 2009 13:16:24 GMT

Hi,

Tnks Abu, but it still doesn't work, pls se the attached file with the code. It's a very stripped bit of code just to show the problem.
To add the date is always a good idea though.

Christina

AddMonths in set analysis?

Fri, 09 Oct 2009 13:50:04 GMT

Hi Christina,

it´s working now. You missed brackets in your expression and please avoid spaces.

Have a nice weekend!

Rainer

AddMonths in set analysis?

Fri, 09 Oct 2009 14:34:30 GMT

Thanks very much Rainer,

I really appreciate you taking the time to correct my misstakes.
I found set analysis very useful, but a bit hard to get right.

I also wish you a nice weekend.

Christina