topic Re: Variable does not work in alternate state? in QlikView

Variable does not work in alternate state?

msmichael — Sat, 16 Nov 2024 03:09:26 GMT

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

Re: Variable does not work in alternate state?

lironbaram — Thu, 27 Jun 2019 19:50:43 GMT

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

Re: Variable does not work in alternate state?

msmichael — Thu, 27 Jun 2019 20:54:55 GMT

Thank you very much!