Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Variable contents lost after adding shortcuts

I have variables in the SETTINGS | DOCUMENT PROPERTIES | VARIABLES Tab

The variables use formulas based on the selected record and are used in macro to create an email in Outlook.


I was making changes to the worksheet when I noticed that the the email that was being created was blank. I checked the variables and found the value field for the variables werre blank. So I cancelled the changes and didn't the worksheet.


I opened the worksheet and checked the formulas where present and then started to make the changes again...I was adding shortcuts.


I checked the variables again and noticed that the variables now contained harded coded values rather than the formulas, e.g. the vEmailTo variable should have stored the formula "=ContactEmailAddress" but it actually had a hardcoded value of "[mark.boomer@9habu.com | mailto:mark.boomer@9habu.com]".

I am using the Personal edition 10.00.9277.8 SR4 64xBit (x64) Edition


I did check that the "include in shortcuts" checkbox was selected