topic Re: Alert Condition-Really urgent in QlikView

Alert Condition-Really urgent

Tue, 27 May 2014 19:44:02 GMT

Hello All,

I am using personal edition < I have an expression BCR

sum( {$<clean_message = {"Unreadable Sample ID (BCR 2)","Unreadable Sample ID (BCR 3)"}>} quantity)/sum( {$<id = {tubes},msg_desc = {"CentrifugeCounter"}>} msg_daily_count))*100

and a threshold Value , and on the dimension I have date, I have to trigger and alert whenever the threshold is greater than number of consecutive days that user enters in an inputbox, say if BCR2 > threshold than 3(entered by user) than an alert should be fired, can someone please help me with this ? Please have a look at the attached picture.

Thanks and Regards,

Ronak Jain

Re: Alert Condition-Really urgent

Tue, 27 May 2014 22:45:17 GMT

Steve Dark

Jagan Mohan

Marc Littman

Re: Alert Condition-Really urgent

rwunderlich — Thu, 29 May 2014 02:42:17 GMT

Alerts -- those defined in the tools menu -- are only tested on document open or post reload. If you want the user to enter a value after opening the document, it's too late -- the alerts have already been tested. Am I misunderstanding your question?

-Rob

Re: Alert Condition-Really urgent

jagan — Thu, 29 May 2014 03:17:42 GMT

Hi Ronak,

I think alert is not possible in your scenario, Can you Highlight this with different background color or Show some text objects with some message when this condition is met. Can you attach some sample file and the condition.

Regards,

Jagan.