topic Select multiple values in a field action in QlikView

Select multiple values in a field action

danosoft — Tue, 20 Mar 2018 09:51:51 GMT

Hi i want to select multiple values in a field from my Button, i try to explain:

i have those button:

When i click 01 it will select the value 01 from my field "mesefineforn"

"Mese01" is my variable for select and deselect my value in the field "mesefineforn"

My problem is: When i click in '02' i want in my field "mesefineforn" it will set 01,02

not only 02.

when i will click in 03 the same it must be set : 01,02,03 and so on...

how can i do that with my buttons actions?

Thanks

Re: Select multiple values in a field action

tamilarasu — Tue, 20 Mar 2018 09:59:31 GMT

Hi Daniele,

You can try search string like (01|02|03) for multiple value search.

Re: Select multiple values in a field action

danosoft — Tue, 20 Mar 2018 10:01:38 GMT

ok but i need to put at runtime clicking to my buttons those values to set..... like you see in example, how can i do that?

Re: Select multiple values in a field action

tamilarasu — Tue, 20 Mar 2018 10:12:58 GMT

Daniele Caprelli wrote:

i want to select multiple values in a field from my Button, i try to explain:

i have those button:

You have to hard code those values in each button action.

Button 01 => 01

Button 02 => (01|02)

Button 03 => (01|02|03)

and so on.

Re: Select multiple values in a field action

tamilarasu — Tue, 20 Mar 2018 10:18:50 GMT

Daniele Caprelli wrote:

ok but i need to put at runtime clicking to my buttons those values to set..... like you see in example, how can i do that?

I think both the questions looks similar.

'Ctrl' click by actions in Text boxes on same field

Re: Select multiple values in a field action

danosoft — Tue, 20 Mar 2018 10:45:02 GMT

I think my question is little bit different

my problem is:

in my Button 01: when i choose it i need to do the thing like you see in the picture i sent before, and i write there:

field: MESEFINEFORN set =if($(MESE01)=1,null,01)

when i click in Button 02 (or 03...12) i need to set in field MESEFINEFORN : if($(MESE02)=1,null,02)

i need in these scripts put something for concatenate the values if i had set value in field with another of others 12 buttons

example: =if($(MESE01)=1,null,<THERE I NEED TO PUT THE EXPRESSION FOR CONCATENATE POSSIBLE VALUES IF I HAD CLICK IN OTHERS BUTTONS BEFORE>)

sorry if i wrote in uppercase, is only for show you where i don't know what i need to write

Thanks

Re: Select multiple values in a field action

tamilarasu — Tue, 20 Mar 2018 11:02:45 GMT

If I understood you below one should work.

Button1:

=if($(MESE01)=1,Null(), '(' & GetFieldSelections(MESEFINEFORN, '|') & '|01)'

Button2:

=if($(MESE01)=1,Null(), '(' & GetFieldSelections(MESEFINEFORN, '|') & '|02)'

Re: Select multiple values in a field action

danosoft — Tue, 20 Mar 2018 11:23:22 GMT

Yes, you understood, but it not work 😞

=if($(MESE01)=1,Null(), '(' & GetFieldSelections(MESEFINEFORN) & '|' & '01)'

'01' is a string to set.... perhaps is that the error in condition?

and... i think... looking the script if i choose this button for first (all buttons can be choose for first) ... it will set |01 so... i think it will not set the correct walue

btw... this script not work

sorry

Re: Select multiple values in a field action

tamilarasu — Tue, 20 Mar 2018 12:03:21 GMT

Daniele - Sorry, I was travelling so sorry for the delay. Have a look at the attached file.

Re: Select multiple values in a field action

danosoft — Tue, 20 Mar 2018 15:54:13 GMT

Thanks, is ok....

but only a thing is missing, when i Click for example in BU 01 the second time it must REMOVE the value from the field

Re: Select multiple values in a field action

danosoft — Wed, 21 Mar 2018 07:35:51 GMT

Is possible to do that?

Re: Select multiple values in a field action

tamilarasu — Thu, 22 Mar 2018 04:18:16 GMT

Have a look at the attached file. I have included all the possible scenarios. Let me try to simplify the expression when I get time. Let me know if you have any issues.

Re: Select multiple values in a field action

danosoft — Fri, 23 Mar 2018 11:05:32 GMT

This is good, thanks,

only a thing, i have buttons when i click those change colors, for that i set the variable MESE01 to 1 and variable MESE02 to 1 and so on.....

but if i set those, when i click in buttons they stop to work

i changed your .qvw adding my two buttons hope you can see it

Re: Select multiple values in a field action

tamilarasu — Fri, 23 Mar 2018 11:16:43 GMT

Just a quick question. What is the use of the variables MESE01, MESE02 .. Is it only for to change the color or are you using those variables somewhere?

Re: Select multiple values in a field action

danosoft — Fri, 23 Mar 2018 11:20:43 GMT

i use only for change colour, i want when i select my button it will change so i can see it is "clicked" or not

Re: Select multiple values in a field action

tamilarasu — Fri, 23 Mar 2018 11:32:00 GMT

Have a look at the attached file. This will work even if you press the clear all button. Check with all the possible cases and let me know your thought.

Re: Select multiple values in a field action

danosoft — Fri, 23 Mar 2018 14:18:23 GMT

Thanks now work fine, really thanks, great!!