topic Re: Button to select certain areas in field in QlikView

Button to select certain areas in field

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

I need help creating a button that will select a certain field

my task is to create a button that can select the category product but i only want 1-5 and not the other 4

The button must be a selecetion button

the field selected has to be defined.

Cheers guys if you can help me

Re: Button to select certain areas in field

aaronnayan — Tue, 21 Feb 2017 10:42:11 GMT

SORRY GUYS LET ME MAKE IT EASIER

i want a button that will SELECT certain values in a specific field

Re: Button to select certain areas in field

ramasaisaksoft — Tue, 21 Feb 2017 11:15:38 GMT

means these values are changed randomly?

means if the list box having 100 records you are selecting 1 to 10 first time

11 to 20 next time like this... etc?

Re: Button to select certain areas in field

ramasaisaksoft — Tue, 21 Feb 2017 11:18:12 GMT

if it is static just create a book mark and in button action just create a action to activate the Book mark.

Re: Button to select certain areas in field

pix — Tue, 21 Feb 2017 11:27:58 GMT

Hey Aaron,

There is an option in the Actions tab (Selection >> Select in Field) where you can define the Field Name and also mention a Search String (depending on certain values or a formula).

Hope this helps,

Diana

Re: Button to select certain areas in field

sasikanth — Tue, 21 Feb 2017 11:31:16 GMT

HI,

Make product field as Dual like

*****************************

Load *,

Dual (Product,RowNo()) As Product1,

FROM Table;

*************************************

Create a Button--> Add action --> Select in Field

FieldNmae : Product1

Search string : <=5 (of your choice)

Note: Products sorting order depends on Loading Order

Just give a try