Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER 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
Partner

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
Partner

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

msmichael
Creator
Creator
Author

Thank you very much!