if excluded value selected, don't take it into account on filter but use it in table

[YoussefBelloum]

Hi Everybody,

I'm stuck on something

here is the load inline for example:

table:

LOAD * Inline [

Material, Customer, Value

1, Cust1, 10

2, Cust1, 20

3, Cust1, 30

4, Cust2, 40

5, Cust2, 50

1, Cust2, 60

];

and here is a small description of what I'm trying to achieve

I was thinking about a solution consisting on returning back one step (as soon as I select the Value2) and use a set analysis to force that value on the first expression...

Every recommendation/solution is welcome

PFA

thank you

[sunny_talwar]

May be using Alternate State?

[YoussefBelloum]

thank you sunny,

If i follow the steps decribed above:

1. select cust2

2. select Material 2

the table displays all the lines (I need only the line of Material 2)

and the most important, the Value Cust2 is unselected automatically (want to avoid that)..

[sunny_talwar]

Is this not what you wanted?

There are two Material list boxes above... one is in default state and other one in alternate state...

[YoussefBelloum]

I don't have the second listbox... tried to display all the object on security tab but Can't find it..

[sunny_talwar · Accepted solution]

Not sure I understand? Check the attached qvw

[YoussefBelloum]

on your first attachement, there is only one Material listbox..

this one is good

there is no alternative to this, using something else? an alternative that unselect the Value 2 on Material but keep filtering the table using that Value (with set analysis for example) ?

[sunny_talwar]

Selecting in a straight table dimension is the same thing as selecting in a list box... what you are asking is to break the associative properties of QlikView... you can break it using alternate state and island tables, but that is about it... I don't think there is another way. Also, set analysis in the expression means nothing much for selections in dimensions.

HTH

[YoussefBelloum]

I see..

Any information is useful, thank you