Creating QV Alert

[#1]

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

[sudeepkm]

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)

[#3]

Thank U Sudeep

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

[sudeepkm]

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

[#5]

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

[sudeepkm]

Do you want to count

1. the number of values in that Field

or

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

[sudeepkm]

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.

[#8]

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

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

[sudeepkm]

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.

[#10]

Please See att