Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anavin33
Not applicable

State of different sheets

I have five sheets in my qlikview document. Three of the sheets are the same "alternate state" so that the current selections transfer across sheets. The other two are their own separate states. I want to make the last two sheets the same state so the current selections will transfer across all five sheets.

My problem is that there are different variable that represent the same thing on the two different types of "alternate state". Is there a way I can manipulate the current selections or something to make it so if either of the two variables has a selection, it works for both?

EX:

One sheet is using the variable "Stage" as the stage of the loan. The other sheet uses the variable "PresentStage" as the stage of the loan. The two variables are necessary because they are coded to display a certain stage for the loans. But when I make a selection in "Stage" I would like the selection to also be made in "PresentStage" and vice versa. Is there any way to do this??

3 Replies
vardhancse
Not applicable

Re: State of different sheets

using alternate state separately we can not pass the selections.

Those 2 fields are coming from the db or else in QV level ur creating calculated dimension

anavin33
Not applicable

Re: State of different sheets

The two fields "Stage" and "PresentStage" are both created in the script. If all the states of the sheets are the same then is there a way to make those two fields one and the same?

vardhancse
Not applicable

Re: State of different sheets

any way both are created in script. make it in to one field name because both populates the same value.

yes if all the sheets state was same, the selections will pass through all the sheets