topic Re: Filter specific word in strait table in QlikView

Filter specific word in strait table

tappij2012 — Mon, 09 Jan 2017 12:31:16 GMT

How do I make filter with in a strait table, where I use one dimension and several expressions?

I'll want to make different tables, where I want to use this filter.

For example:

So I'll want to use => if(Customer = '*We*', Customer) to show one table with all the customers contains 'We'.

When I'll do this, it doesn't show these customers, but only a -

Normally, when dimension is Customer, it shows of course all the customers.

sunny_talwar — Mon, 09 Jan 2017 12:33:15 GMT

Are you using this as dimension or expression? I hope as a dimension? Would you be able to a share a sample where this isn't working?

jonathandienst — Mon, 09 Jan 2017 12:47:35 GMT

The = operator cannot do this sort of search, use Like instead:

if(Customer Like '*We*', Customer)

But, as Sunny said, the correct solution depends on where/how you are planning to use it.

tappij2012 — Mon, 09 Jan 2017 12:48:30 GMT

For Example:

I want to see a table witch shows only the rows 2 and 4 for this case.

sunny_talwar — Mon, 09 Jan 2017 12:49:37 GMT

Try like this

If(WildMatch(Customer, '*We*'), Customer)

tappij2012 — Mon, 09 Jan 2017 12:55:59 GMT

Thanks for your answer. This helps!

jonathandienst — Mon, 09 Jan 2017 13:47:26 GMT

Either of these should work as a dimension (they are functionally the same so which one to use is simply a matter of style):

If(Customer Like '*We*', Customer)

If(WildMatch(Customer, '*We*'), Customer)

Remember to suppress null values in the dimension.