Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
so can you tell me how to apply alternate states to solve this problem ?
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.
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
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..
May be this
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..
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?
like this
should be able to filter the table with selection on the first listbox and the second listbox
I think you have not attached the updated sample... still just show the two list boxes and there is no amount field
sorry, i have updated the app just above