Excluding Filter selection when it's used an expression

[#1]

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

[hariprasadqv]

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

[awhitfield]

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

[#4]

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?

[rubenmarin]

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.

[#6]

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

[rubenmarin]

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

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

[#8]

It works

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

Thanks again!!!!

[rubenmarin]

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.