topic Re: Hiding Filtered Rows in QlikView

Hiding Filtered Rows

Mon, 29 Jun 2015 17:45:27 GMT

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 — Mon, 29 Jun 2015 19:20:01 GMT

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 — Mon, 29 Jun 2015 21:06:29 GMT

Use this field expression in your listbox:

Aggr(D_Children, D_Children)

hope this helps

regards

Marco

MarcoWedel — Mon, 29 Jun 2015 21:17:50 GMT

like this:

hope this helps

regards

Marco

Tue, 30 Jun 2015 16:45:00 GMT

Thank you!

MarcoWedel — Tue, 30 Jun 2015 18:01:33 GMT

you're welcome

regards

Marco