topic Re: All values excluded when value selected in QlikView

All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:17:49 GMT

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

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 13:29:01 GMT

Chart expression or list box expression? Can you elaborate on what is expected?

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:33:12 GMT

Hi Sunny,

by chart expression, i mean object expression, no matter which type of object (just don't want to modifiy the script)

Re: All values excluded when value selected

stabben23 — Fri, 24 Nov 2017 13:39:00 GMT

But these are values from one single Dimension. Dimensionvalues dont have Connection to each other.

If you want to Connect them, use scriptview.

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 13:41:14 GMT

That is fine to not modify the script... but what is the expected output here? Is the output needed in a list box object or a chart?

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:44:36 GMT

ok, for example, if i select 'a' on the first listbox, i want to see all the values (available) on the second listbox..

so 'a' on the first listbox and be able to see and select 'a 1','b 1','c 1','d 1','e 1','f 1','g 1' on the second listbox

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:45:45 GMT

I just split a column in two parts, I'll still try to do it without the script.. thank you

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:47:05 GMT

and vice versa if it is possible

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 13:47:13 GMT

Only way you can do this is by using alternate state or script modification... but since script is out of question... I would say alternate state

Re: All values excluded when value selected

stabben23 — Fri, 24 Nov 2017 13:49:12 GMT

maybe alternate states then?

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:49:13 GMT

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

Re: All values excluded when value selected

pradosh_thakur — Fri, 24 Nov 2017 13:49:20 GMT

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.

Re: All values excluded when value selected

pradosh_thakur — Fri, 24 Nov 2017 13:56:09 GMT

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

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:57:17 GMT

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..

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 13:57:27 GMT

May be this

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 13:58:07 GMT

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..

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 13:58:37 GMT

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?

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 14:00:29 GMT

like this

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

Re: All values excluded when value selected

sunny_talwar — Fri, 24 Nov 2017 14:04:26 GMT

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

Re: All values excluded when value selected

YoussefBelloum — Fri, 24 Nov 2017 14:07:18 GMT

sorry, i have updated the app just above