Two conditions on Text Box - QlikView

[Sou]

Hi,

I am trying to get the data from previous month and also that has a specific condition. I am using this formula:

count({<Column.Variable = {'Condition'}>}Column.Variable), count(InMonth(Date.DateAppointment,today(),-1), [Record_ID]))

I can use both conditions separate but cannot find the way them together to get the records for that specific condition for the previous month.

Thanks,

[BrunPierre]

This might be what you are looking for.

=Count({$<Column.Variable = {'Condition'}, Date.DateAppointment = {"$(=MonthStart(AddMonths(Today(), -1)))<=$(=MonthEnd(AddMonths(Today(), -1)))"}>} [Record_ID])

[Sou]

It doesn't work, it gave me 0, I created a variable, this is what I have that also gave me 0:

Count({<ColumnVariable={'Reject'},Date.DateAppointment={'$(vPreviousMonth)'}>} Record_ID)

[BrunPierre]

The reason could be that the dates are formatted differently.