Something went wrong while trying to load the full version of this site. Try hard-refreshing this page to fix the error.
Release [4.6.0] AnalyticsGate Excel Add-In
New Features since 4.5.0
new User Defined Function SenseCalculated (see
Extend tables with Excel Formula Columns
one can insert and append columns containig Excel formulas.
So, you can have a mix of Qlik and Excel Formula Columns. The Excel Formulas will be integrated into the tabledefinition.
During a table refresh all Excel Formula Columns are calculated after the Qlik Columns are filled
References to other cells can be integrated into the Formula, so the whole Excel formula column recalculates when this referenced cell changes.
Reporting also calculates this formulas
Added 'Goto Table' Button for table user info messages, to fast jump to the table and open the corresponding definition
if the condition isn't true, the corresponding error message is displayed as data of the Table and in the Info Panel.
Import Object Combobox is now grouped by sheet name