Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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 (2)
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!