Problem with alerts

[#1]

Dear all,

I have a problem creating alerts.

I have created an alert an Open with that condition and no other selection

=numericcount({$<[FN] = {">$(#=v_MaxDate)"},[CN]={'000'},[CO]={'999'},[TR]={'E'},={'P'},[BS]={'0'}>} distinct [NO])>0 .

When I open QV, usually memory used is 300.000 but when I activate that alert, It goes till 2.000.000 and makes an error.

Clause is good composed, but I thing that when alert goes to send an e-mail is working wit all records. Is it working with all records or only with those from the condition?

On first case, How I do to compose to work only with the selected ones.

On messege body I'm sending

=Concat ([NO],';')

Best regards and thanks for your hep

[#2]

Problem that I have is that I can't create a Marker, because I am using a variable that is a date and I dont know how to do a field equal to a variable.

Best regards

[Oleg_Troyansky]

I'm pretty sure that the "CONCAT" function in the body of your alert is concatenated l the numbers [NO], -your SET Analysis condition only applies to the expression with the NumericCount(). At the minimum, ou have to populate the sam SA condition for the concat().

[#4]

But How I have to populate it.

If I create a Mark, i need that a field called data be greater than a system variable, but I don't know how to do it on selection

I have created a mark with a lot of selections, but I don't know how to do this.

Best regards