topic Re: Table as a Filters in QlikView

Table as a Filters

Fri, 05 Aug 2011 14:43:47 GMT

I have two tables in a sample of information of all available data on the other I have a table of data that need to use as filters, that is, when I select the search field "Bodega" I should select all data containing the word in the description “Bodega“.

So I can get the total value of all descriptions that contain "Bodega" in their description.

I hope someone can help me.

Thanks and regards,

Enrique Quispe

Re: Table as a Filters

Fri, 05 Aug 2011 15:27:40 GMT

Try this expression

=COUNT(IF(Descripción LIKE '*BODEGA*', Descripción))

You can change '*BODEGA*' to GetFieldSelections([Campo Buesqueda], ',', 1)

Re: Table as a Filters

Fri, 05 Aug 2011 20:37:51 GMT

I try it,but it doesn’t work. I attach anexample.

Re: Table as a Filters

Fri, 05 Aug 2011 20:53:58 GMT

Hi, see this example

Re: Table as a Filters

Fri, 05 Aug 2011 21:18:08 GMT

Thanks, this was what I needed.