Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

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