topic Re: Dynamic filters in QlikView

Dynamic filters

Wed, 17 Feb 2016 14:20:57 GMT

Hello all,

I want to make a filter depending of the value of a dimension. To be more clear, I want to create table with Publishers in dimension and the sum of sales in expression. But for certain publishers, I want only the sales of books, for another only for the videogame, for another one, the books and videogames.

Could you help me on this?

Thank you ,

Re: Dynamic filters

sunny_talwar — Wed, 17 Feb 2016 14:24:16 GMT

You can use set analysis for doing this:

Sum({<Publisher = {1}, Product = {'Books'}>+<Publisher = {2}, Product = {'VideoGames'}>+<Publisher = {3}, Product = {'Books', 'VideoGame'}>}Sales)

Re: Dynamic filters

Wed, 17 Feb 2016 14:37:13 GMT

Thank you verry much Sunny it's working