Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Create a button that shows the selections on a different field.

Hello,


I have 2 list boxes namely year and month (that contain different year and month selections). These selections currently apply on my Order Date field.

I want to create a button or any other functionality that would allow me (or any user) to apply these selections on the Billing Date field.

Thanks!

1 Solution

Accepted Solutions
hector_munoz
Valued Contributor

Re: Create a button that shows the selections on a different field.

OK, look at the attached sample. Regards!

View solution in original post

14 Replies
hector_munoz
Valued Contributor

Re: Create a button that shows the selections on a different field.

Hi Rahul,

I attach you a sample. Hope it is useful!

Regards,
H

Not applicable

Re: Create a button that shows the selections on a different field.

Hey,

That is the functionality I needed. But, I want it to be on the same dataset (the same table that shows the data, but the selection applies on a separate field when I press the button). Is that possible?

Thanks

hector_munoz
Valued Contributor

Re: Create a button that shows the selections on a different field.

Hi,

Yes I think thats possible. It doesnot matter the tables where the fields reside: in different or the same. Have you had any problem?

Regards,

H

laddu_927
Valued Contributor

Re: Create a button that shows the selections on a different field.

Like this??

Not applicable

Re: Create a button that shows the selections on a different field.

The other field I am trying to assign the button to has only one field called Billing Date US . It is not broken down into year and period (month). Could you help me with how to do that? I am pretty new so i would like you to elaborate as much as you can. Appreciate it!

Thanks!

hector_munoz
Valued Contributor

Re: Create a button that shows the selections on a different field.

OK, look at the attached sample. Regards!

View solution in original post

Not applicable

Re: Create a button that shows the selections on a different field.

Hey,

So what does the Field value and the search string value do in the Button Properties tab. Isn't that the only thing i have to look at while carrying out this functionality,

hector_munoz
Valued Contributor

Re: Create a button that shows the selections on a different field.

Hi,

When you press the button, its functionality selects the possible values in Date1 into the Date2 field values. It does not matter what is selected in other fields.

Regards,

H

Not applicable

Re: Create a button that shows the selections on a different field.

So, will the date 1 fields be changed to different values according to the selections that are now in the date2 field.
They should right? or only those fields are selected in which both the date1 and date2 fields are same.

Thanks,

R