Alert condition

[#1]

Hi,

I need to check the sales of each country and if any of the country has sales less 3000 then a message should be displayed.

How to do this using alerts?

[rohit214]

hi

Can you Plaese tell me how do you dot that...

means how do you show the alert

thanks & best regard

rohit

[#3]

Hi Rob,

where do I define the search condition which you wrote above?

what do I write in the field where I define which text should be written in the alert mail? Now I have <=Country & ' has Sales less than 10'> (without the <>) but in the mail the place of Country is empty...

Thanks,

Martin

[rwunderlich]

You define the search condition in the Country listbox. Just as a standard search like:

=Country=sum(Sales)<10

Save this as bookmark. Then specfify this bookmark in the Alert definition.

You are probably getting an empty Country in the mail because you have more than one Country. Try

=concat(Country, ',') & ' has sales less than 10'

-Rob

[#5]

Hi Rob,

thanks a lot, that works great.

I just have another question: Did I get it right in other discussions that alerts (batch-mode enabled) are not fired when the reload is executed by the qlikview-server??? If yes, is there a chance without macros for a workaround?

Thanks,

Martin

[rwunderlich]

There have been problems discussed on the forum, but batch mode alerts work for me on the server.

-Rob