topic List box task in QlikView

List box task

Sun, 14 Jun 2015 15:44:28 GMT

i want to hide a field value which are having 'a' as a first letter in name.............

For example in list box field is salesman....then i want to show without salesman names which are consist a as a first letter at script level

if u create a list box with salesperson field in script level u shoud comment the name which is have starting letter a (aravind)

swuehl — Sun, 14 Jun 2015 15:50:15 GMT

I haven't understood if you want the salesperson just to hide from the list box or you want to exclude them when reloading data:

List box: Create an expression (select <expression> from field list dop down):

=if( lower(left(salesperson,1)) <> 'a', salesperson)

In the script, you can use a where clause:

LOAD

salesperson,

sales,

...

FROM ...

WHERE lower(left(salesperson,1)) <> 'a';