topic Create a button that shows the selections on a different field. in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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!

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

hector_munoz — Fri, 28 Apr 2017 15:28:24 GMT

Hi Rahul,

I attach you a sample. Hope it is useful!

Regards,
H

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

Fri, 28 Apr 2017 15:37:17 GMT

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

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

hector_munoz — Fri, 28 Apr 2017 15:41:49 GMT

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,

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

Anonymous — Fri, 28 Apr 2017 15:46:02 GMT

Like this??

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

Fri, 28 Apr 2017 15:56:32 GMT

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!

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

hector_munoz — Fri, 28 Apr 2017 16:01:26 GMT

OK, look at the attached sample. Regards!

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

Fri, 28 Apr 2017 17:20:32 GMT

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,

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

hector_munoz — Fri, 28 Apr 2017 18:21:04 GMT

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,

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

Sat, 29 Apr 2017 14:04:43 GMT

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,

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

ecolomer — Sat, 29 Apr 2017 14:49:22 GMT

See this example:

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

Mon, 01 May 2017 12:58:59 GMT

Your test case isn't doing anything. I know the code that he gave keeps the both date fields selected I want to create a button that changes the selections to a different date field according to which the other date field that was previously selected is changed.

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

Mon, 01 May 2017 13:42:44 GMT

Can you tell me why is '|' being used in the concat function. Thanks!

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

hector_munoz — Mon, 01 May 2017 17:42:41 GMT

Hi Rahul,

When you want to select some values in a field box introducing an string, not by pressing CTRL key + clics, you have to list them among pipes and inside (). E.g: (Spain|Italy|Portugal)

Regards,

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

Mon, 01 May 2017 17:46:08 GMT

Thanks a lot... for your help. Although, your answer did not completely solve my problem it definitely helped me a lot. Appreciate it!