All values excluded when value selected

[YoussefBelloum]

Hi guys,

I'm not able to do something,

you can find attached the QVW

i have one column "dimension" and two listbox's with one expression each, like this:

=if(not Match(dimension,'a 1','b 1','c 1','d 1','e 1','f 1','g 1'), dimension) => for the first listbox

=if(not Match(dimension,'a','b','c','d','e','f','g'), dimension) => for the second listbox

for example, when i select a value on the first listbox, all the values for the second listbox goes grey (excluded).

i just to be able to select values on both listboxes.

PS: there is solutions on the script, but i want to do it with chart expressions (if it is possible)

Thanks

[YoussefBelloum]

so can you tell me how to apply alternate states to solve this problem ?

[pradosh_thakur]

Hi

I don't think that is possible without using alternate state. As they are from the same dimension , others will gray out when one value is selected as they are not related/associated. that is how qlikview behaves. You can add a list box with dimension and check out it will have green color selection.

[pradosh_thakur]

Go to document properties-> alternate states-> add alternate state -> give a name ->A

Go to any of the list box general tab-> top left-> alternate state-> A

[YoussefBelloum]

I should have specified that these two listboxes is associated to a straight table as a dimension..

but with this solution of alternate state, i cant use them to filter a straight table..

[sunny_talwar]

May be this

[YoussefBelloum]

yes, i have tried it, but like i said now to sunny:

I should have specified that these two listboxes is associated to a straight table as a dimension..

but with this solution of alternate state, i cant use them to filter a straight table..

[sunny_talwar]

You can still use them in a single straight table... that is what I wanted to understand... where are you using this? Can you update your sample to add the list box?

[YoussefBelloum]

like this

should be able to filter the table with selection on the first listbox and the second listbox

[sunny_talwar]

I think you have not attached the updated sample... still just show the two list boxes and there is no amount field

[YoussefBelloum]

sorry, i have updated the app just above