topic Re: Filter in QlikView

Filter

spividori — Wed, 15 Oct 2014 15:16:27 GMT

Hi.

I have the following application:

Where the total Vta Product C is 4.

When I selected the Prove R, I need the total of Vta remains 4.

I use the following expression: Sum({<Prove= >} CantVta), but it shows me all the products and you should see the products Prove R.

The result should be next:

Attached the example.

Regards.

Wed, 15 Oct 2014 15:19:27 GMT

Hi,

Try this

Sum({<Producto={'C'} ,Prove=>} Cpra),

spividori — Wed, 15 Oct 2014 15:26:43 GMT

This is an example, the products can be one or more in my real application.

Regards.

spividori — Thu, 16 Oct 2014 01:08:04 GMT

HI,

Any idea ?, help please.

Regards.

jagan — Thu, 16 Oct 2014 02:37:04 GMT

Hi,

Try this expression.

=Sum ({<Producto=P({$<Producto>}), Prove= >}CantVta)

Regards,

Jagan.

spividori — Thu, 16 Oct 2014 12:49:12 GMT

Hi.

Thanks for responding.

I modified your expression as follows: sum( {$<Producto = P({$} Producto), Prove = >} CantVta)

When I select a Prove that had several products, when I select a product showing all products of this Prove.

This way allows me to filter the products also.

Regards.

jagan — Fri, 17 Oct 2014 01:59:12 GMT

Hi,

If you got the solution please close this thread by giving correct answer to the useful post.

Regards,

Jagan.