topic Re: Excluding Filter selection when it's used an expression in QlikView

Excluding Filter selection when it's used an expression

Wed, 18 Mar 2015 09:03:41 GMT

Hi,

I have defined a listbox as expression, like that:

if(Manufacturer='A', PRD)

Now in my dashboard i have some graph which should consider the filter above and other does not.

For the second type i have tried to use a set analysis expression like that:

sum({$<PRD=>}[Value2])

But it's not working. Of course it works if I have a listbox defined directly on the PRD field but when I'm using an expression it doesn't.

Really appreciate if anyone could help on it.

Thanks,

Anto

Re: Excluding Filter selection when it's used an expression

hariprasadqv — Wed, 18 Mar 2015 10:46:24 GMT

Hi,

Your set expression is for not to select any value of PRD field if you are having a field named as PRD, and it will sum all the values in the field Value2

Re: Excluding Filter selection when it's used an expression

awhitfield — Wed, 18 Mar 2015 11:00:52 GMT

What are you actually trying to here!

This means, just list PRD from Manufacturer A

This means sum Value2, for selections, but ignore any selection made on the PRD dimension

Andy

Re: Excluding Filter selection when it's used an expression

Wed, 18 Mar 2015 16:16:35 GMT

Hi, first of all thanks for your reply.

Got your point, and i noticed that. But the question is, how can i define an expression in a graph which does not consider the choice made on the listbox?

Re: Excluding Filter selection when it's used an expression

rubenmarin — Wed, 18 Mar 2015 16:34:37 GMT

Hi Antonello, when you select a value in that list box, wich field shows filtered in 'Current selections'?

Most probably it's also selecting Manufacturer.

Re: Excluding Filter selection when it's used an expression

Wed, 18 Mar 2015 16:46:37 GMT

It shows all the values. I'm pretty sure that my approach it's not the correct one.

Maybe i should ask more general question:

- How can i define a listbox which shows only some specific values (eg. product which belongs to a manufacturer) and have in the same sheet a graph which should not be affected by the listbox selection?

Real example:

Graph1: Total Market value

Graph2: Total Manufacturer

Graph3: Total Product

Graph3 - Total product, should show only the value for the specific product selected in the listbox and which belongs to a static manufacturer.

Graph1 and 2, instead, should show the total value always.

Hope it helps to clarify my need and question.

Thanks,

Antonello

Re: Excluding Filter selection when it's used an expression

rubenmarin — Wed, 18 Mar 2015 16:50:17 GMT

Hi Antonello, perhaps you can use this expression in the list box:

=Aggr(Only({1<Manufacturer={'A'}>} PRD), PRD)

Re: Excluding Filter selection when it's used an expression

Wed, 18 Mar 2015 16:57:19 GMT

It works

Could I please ask you what you're expression specifically does and why mine was not working?

Thanks again!!!!

Re: Excluding Filter selection when it's used an expression

rubenmarin — Fri, 20 Mar 2015 08:46:39 GMT

Hi Antonello, I can't give a real answer to that but my thoughts are that using Manufacturer inside the if makes Qlikview think that you are using both filters to create the list, so each item is related to both fields.

Using set analysis created first it creates a dataset where Manufacturer='A', from there starts the 'real' expression wich only uses the PRD field, so at the end only the PRD field is filtered when selecting an item.