topic Re: Creating QV Alert in QlikView

Creating QV Alert

Wed, 22 Jan 2014 09:58:20 GMT

Hi Everybody

I want to create a alert after reload , if the number of characters of my fields CCN is more than 13 characters

The system must be alble to show just a rows that number of character is more than 13

Thank u for help

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 10:14:01 GMT

You can use the alert wizard to implement an alert in the document.

Define your "Condition" expression, Set Events as On Post Reload, Set Mode as Batch (to run in Server mode) and Set Delay (Frequency of Alert if needed)

Re: Creating QV Alert

Wed, 22 Jan 2014 10:23:07 GMT

Thank U Sudeep

Do you have a idea to about the synthax expression of my codition ? How to if (sum(of character)) != 13)

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 10:29:05 GMT

I think to find the number of character you can use Len() function.

Re: Creating QV Alert

Wed, 22 Jan 2014 10:36:59 GMT

It doesnt work len([ref nom])>=13 len fonction return me 0

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 10:40:44 GMT

Do you want to count

1. the number of values in that Field

2. the maximum number of characters present in the Field values

To count the Number of values of that field you may use the given below expression

Suppose the Field name is City

count(DISTINCT {<[$Field]={'City'} >} City). This will give you the number of values present in the field City

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 10:46:01 GMT

to calculate the lengthiest character field value please use

max(len([yourfieldname])) >=13 in the alert condition.

So that if any one the field value has more than or equal to 13 characters then the alert will be generated.

Re: Creating QV Alert

Wed, 22 Jan 2014 11:19:45 GMT

The max ( len ()) fonction doesnt return a true value

For exmaple i test fields with ( 1234567891234) the fonction return me 20

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 11:24:03 GMT

Do you have a sample qvw or qvw with scrambled data that you can share? I just wanted to check the field and its values.

Re: Re: Creating QV Alert

Wed, 22 Jan 2014 12:58:47 GMT

Please See att

Re: Creating QV Alert

sudeepkm — Wed, 22 Jan 2014 13:06:34 GMT

Can you please use the alert condition like below and test.

max(len([ref matricule])) >= 13

>= instead of >>

Re: Creating QV Alert

Wed, 22 Jan 2014 13:16:54 GMT

Thank u Sudeep