topic Re: How to Assign selection value to button in QlikView

How to Assign selection value to button

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I have 11 different area names under the field "AREA", Now instead of adding each region (eastern, western...) against each area name I want to add 04 buttons "Eastern", "Western", "Southern" & Northern". what I need is that when eastern button is clicked it should select only those areas assigned to eastern region in button settings.

I have already created 4 buttons just need to learn the coding (if any) in Actions Section of Button Properties for the required output.

OR IF THERE IS ANOTHER ALTERNATIVE

Regards,

Re: How to Assign selection value to button

jonathandienst — Mon, 28 Jan 2019 05:05:40 GMT

I am not sure what you are asking. The field name is the field where you need to make the selection and the search string is the selection itself, for example "Eastern" (without the quotes).

Re: How to Assign selection value to button

nilaksh92 — Mon, 28 Jan 2019 15:54:32 GMT

Can you please elaborate your problem and please share sample data.

Thanks

Nilaksh Mahajan

Re: How to Assign selection value to button

nwest1965 — Mon, 28 Jan 2019 16:43:57 GMT

I'm going to take a guess at what you want to achieve.

Assume you want the following:

Western - AreaWest1; AreaWest2; AreaWest3

Eastern - East1; East2; East3; East4

South - SouthernA, SouthernB

North - NorthernArea1, NorthernArea2

Now, in your button (or text object) you create your title for Eastern and then you go to the Actions tab and add an Action for Select in Field (it's actually the first action available) you put in your field name which is AREA and then you add in the following into the Search String position:

(East1|East2|East3|East4)

That's it, that's all you need.

Re: How to Assign selection value to button

300sss300 — Sun, 03 Feb 2019 10:37:23 GMT

Please see attached file. These Areas fall into 04 regions. Instead of adding another field "Region" having values "Eastern, Western, S N...) and assigning to each 'AREA' Field I want to have 04 buttons with names "Eastern, Western, S N...)" For example when Eastern is clicked it should show me data only related to Eastern Region. Just wanna learn how to assign values in action to these buttons instead of manually adding Region values to a large excel file.

Thanks