Two conditions in one action

[#1]

Is it possible to use two conditions in one action for select?

I want to select the past twelve months.

Not this month and only the past twelve months

I made this formule, but he doesn't work

='>' & date(addmonths(today(),-12), 'YYYYMM')&'AND < '&date(today(),'YYYY')&MaandMin1 -1

Who can help me with this challange?

[brenner_martina]

Hi Dirk,

best use the datefunction Num(Monthname(Today())) = numeric("Feb-2011" )

[disqr_rm · Accepted solution]

Just answered another thread. May help you as well.

http://community.qlik.com/forums/t/40551.aspx

[#4]

With that solution, so my formula will be:

='>' & date(addmonths(today(), -12),'YYYYMM') & ' <' & date(today (),'YYYYMM')

Greetz,

Dirk

Yet this does not work.

He now selects all the months that are also older than twelve months.

[Miguel_Angel_Baeyens]

Hello Dirk,

Here is my answer to something very similar.

Hope that helps.

[disqr_rm]

This very much depends on what field you are trying to select and what content you have in that field. Basically your search string should have exact values as in the field.

[#7]

Miquel that is for an expression.

I use a action.

[#8]

my values are the same.

I tested it with a textbox

[disqr_rm]

Possible to upload a sample qvw here?

[#10]

I got him:

='>' & date(addmonths(today(), -13),'YYYYMM') & '<' & date(today(),'YYYY')&(MaandMin1)

This formula works for me

Thank you all