topic Problem with alerts in QlikView

Problem with alerts

Mon, 12 Apr 2010 12:48:59 GMT

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

Problem with alerts

Mon, 12 Apr 2010 14:04:53 GMT

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

Problem with alerts

Oleg_Troyansky — Mon, 12 Apr 2010 14:14:09 GMT

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().

Problem with alerts

Mon, 12 Apr 2010 14:22:20 GMT

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