topic Re: Transfers the selections using variable in QlikView

Transfers the selections using variable

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

Hi All,

Here is the scenario. I am having two sheets (Home & Trans) which is defined with two unique alternate states.

When user do the selections and clicks "Home" or "Trans" button the selections needs to be transferred to other sheets as well.

Attached the sample applications.

Note:

I dont want to use the "Triggers" on the "selections". Looking for the solution by using variable.

-Jay

Re: Transfers the selections using variable

amayuresh — Thu, 17 Mar 2016 04:21:35 GMT

If selection is impacting on both sheet/tabs objects, then why Alternate States are there ?

May be I am missing somewhere.

Re: Transfers the selections using variable

Anonymous — Thu, 17 Mar 2016 04:27:14 GMT

Hi Mayuresh,

That is my issue/requirement. Though it is same name I cant use it.It is kind of "One day data" against "History Data".

Thats why we moved for alternate state.

-Jay

Re: Transfers the selections using variable

amayuresh — Thu, 17 Mar 2016 04:35:18 GMT

Do you want to provide like below ?

Suppose Year List box in Home sheet having values like 2012,2013,2014,2015 with Selection 2014

and Year List Box in Trans sheet showing Years other than 2014.

Re: Transfers the selections using variable

PradeepReddy — Thu, 17 Mar 2016 04:37:09 GMT

try like this...

instead of applying alternate states to entire sheet, apply the alternate states to charts only not for list boxes.

Re: Transfers the selections using variable

Anonymous — Thu, 17 Mar 2016 04:37:23 GMT

No, in Trans sheet also I need to have 2014 to be selected.

-Jay

Re: Transfers the selections using variable

Anonymous — Thu, 17 Mar 2016 04:40:33 GMT

Hi Pradeep,

Thank you for your reply. In this case how to transfer the selections? Any way i cant link columns which is in both sheets.

-Jay

Re: Transfers the selections using variable

PradeepReddy — Thu, 17 Mar 2016 04:45:41 GMT

Copy Selections from one field to another

Re: Transfers the selections using variable

amayuresh — Thu, 17 Mar 2016 04:49:05 GMT

Can you briefly explain your requirement with sheet object and filters/list boxes on both sheet ?

Provide screenshot of application UI.

Re: Transfers the selections using variable

settu_periasamy — Thu, 17 Mar 2016 05:00:56 GMT

May be you can try with Select in Field Actions.

I just created only for ID and ID_T

Check the Attachment..

Re: Transfers the selections using variable

Anonymous — Thu, 17 Mar 2016 09:10:36 GMT

Hi Settu,

Your solution is close to my requirement. But thing is I dont want to show "(" "|" kind of symblos in current selection box. Also I need to consider the "Alternate State" as well. Let me know if you have any idea on this.

-Jay