Hiding Filtered Rows

[#1]

Hello!

I have some rubbish data in in among the good stuff.

I have filtered it out using another field, but my boxes look like this:

When I select 'hide excluded' they look like this:

Any chance I can filter this data? Either by:

a) I could filter the field used in the example in the loadscript: How do I say 'ignore this field if it is blank or contains a '['  '?

b) Get rid of the grey space in the examples above.

Obviously I think the first option is the better one.

Thank you so much!

Best,

Alex

[marcus_sommer · Accepted solution]

You could an expression for the listbox, something like this:

if(not wildmatch(YourField, '*[*', '*]*'), YourField)

But better is it to make such filter within the script maybe in an additional field like:

if(wildmatch(YourField, '*[*', '*]*'), 'invalid Data', 'valid Data') as YourFieldQuality

- Marcus

[MarcoWedel]

Use this field expression in your listbox:

Aggr(D_Children, D_Children)

hope this helps

regards

Marco

[MarcoWedel]

like this:

hope this helps

regards

Marco

[#5]

Thank you!

[MarcoWedel]

you're welcome

regards

Marco