Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
msmichael
Creator
Creator

Variable does not work in alternate state?

Hi,

In my qvw (attached), I have one field only (cob_date) with some dates.

I created three sheets, and assigned one alternate state for each sheet. 

I created a variable vCob_Date=Only(cob_date)

In each sheet, I have one multi box for user to choose a cob_date, then I put two text boxes, one boxes shows the value of the vCob_date variable, the other one shows the value of formula '='only(Cob_date)=' & only(cob_date)'. It looks like the formula box shows the correct value when I select a date in  the multi box, however the variable box never shows anything.

Does it mean that alternate state does not work for variables? 

 

thanks,

Michael

 

Labels (1)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

you need to change your variable : 

delete the '=' equal sign so the variable should only have only(cob_data)

than change the text box to :='vCob_Date=' & $(vCob_date)

the reason because '=' in variable means the expression is calculated at model level and the variable hold a value 

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

you need to change your variable : 

delete the '=' equal sign so the variable should only have only(cob_data)

than change the text box to :='vCob_Date=' & $(vCob_date)

the reason because '=' in variable means the expression is calculated at model level and the variable hold a value 

msmichael
Creator
Creator
Author

Thank you very much!