Skip to content
KPIBot, an AI analyst for your Qlik apps

Changelog

What is new in KPImailer.

Recent releases across all editions. Subscribe to release alerts to get an email when a new version ships.

  1. v4.7.0

    KPImailer for Qlik Sense

    New features

    • Quarter periods. A report’s date range can cover the previous quarter, the current quarter, or a number of complete quarters back from today, with or without the current one. A file’s or a visual’s own period, a send rule’s own period and an Excel template’s period can use them too. See Quarters.
    • A formula editor for filters. A filter can choose its values with a Qlik formula, such as the last three complete quarters or the five best customers. The editor suggests fields, variables and functions, offers examples, and shows what the formula selects as you type. See Writing a filter formula.

    Improvements

    • Filter formulas are checked. A formula Qlik cannot work out is marked in the editor and stops saving, testing and previewing. Every run checks its formulas first, and when one no longer works it sends nothing and names the filter.
    • Quarters from KPImailer v1. Reports imported from v1 keep their quarter periods.
    • Scroll bars in lists. Long lists show a scroll bar, and a list opens on the option already chosen.

    Fixes

    • Unsaved changes in the report editor. They stay when Qlik cannot be reached for a moment.

    Good to know

    • A report saved with a quarter period cannot be opened by an earlier version of KPImailer. If you ever go back to an earlier version, change those periods first.
  2. v4.6.1

    KPImailer for Qlik Sense

    Fixes

    • Filter values written as a formula, everywhere. A filter value written as a Qlik formula selects the values it is true for wherever the report’s filters apply.
  3. v4.6.0

    KPImailer for Qlik Sense

    New features

    • Report variables. A report can give the app’s variables a value for its runs, such as a range, a target or the tab a container shows, without changing the app. A chart, a table or an attachment can have values of its own, and a value can follow the report’s period, today’s date or the value each email is sent for. See Report variables.

    Fixes

    • Filter values written as a formula. A filter value written as a Qlik formula selects the values the formula is true for, and the filter shows what it selects. See How report filters work.
    • Conditions that compare a variable with text. Sections and send rules that compare a variable with a text value work as expected.
    • Apps with very long object names. These apps sync completely.
    • Variable placeholders. A placeholder never prints a variable named like a password or a key.
  4. v4.5.0

    KPImailer for Qlik Sense

    New features

    • Report filters in order. The period comes first, then each filter in the order you set. Drag a filter, or use its arrows, to change the order; every run follows it. See How report filters work.
    • Filters offer only values with data. Each filter lists only the values that have data for the period and the filters above it, and each field shows how many values it still has.

    Improvements

    • See which filter values have data. Each filter shows whether its values have data. Values without data are greyed and can be removed in one step, and a filter that leaves no data is marked, with the filters after it.
    • Runs use only values with data. A run applies each filter with only its values that have data. When a filter leaves no data, nothing is sent and the run history names the filter.
    • Filters of a file or a visual. Their filters show the report’s period and filters above their own, in the order a run applies them.
    • Preview with no data. Preview says when the report’s filters leave nothing to show, with a shortcut to the filters.
    • Unfinished filters. A filter without a field or without values is pointed out before the report is saved.

    Fixes

    • Every time schedule runs. A report with several time schedules runs on each of them.
    • Filter values in placeholders. Placeholders that show a filter’s values list only the values the report used.
  5. v4.4.1

    KPImailer for Qlik Sense

    Fixes

    • PDF copies of Excel attachments. The PDF copy of an Excel attachment now fits every column of each sheet across the page instead of splitting a wide table over several pages, and the page takes the shape of the sheet. Column headers repeat at the top of every page, the current selections stay above the data, and charts and pictures are no longer cut in two by a page break. A template sheet that has its own print settings in Excel keeps them.
  6. v4.4.0

    KPImailer for Qlik Sense

    Improvements

    • Every Qlik pivot becomes an Excel PivotTable. A Qlik pivot that shows data is now always delivered as an Excel PivotTable, in Excel attachments and in Excel templates. When Excel cannot reproduce something exactly, a short note in the file and in the run history says what, for example hidden totals or text shown as labels. See Excel PivotTables in an attachment and Qlik pivots as Excel PivotTables.
    • Titles and headers as in Qlik. PivotTables in Excel attachments carry the Qlik title, subtitle and footnote, and labels written as expressions show their value for the report’s selections.
    • Large pivots. A pivot too large to build in full is built at the levels that fit, without overloading Qlik.

    Fixes

    • Pivots that need a selection. The editor and the Excel add-in can set up a pivot that only shows data once something is selected, such as a single part number.
    • Updating KPImailer. The installer offers to update an existing KPImailer in every case, instead of sometimes starting a new installation.
  7. v4.3.0

    KPImailer for Qlik Sense

    New features

    • Qlik pivots as Excel PivotTables in Excel attachments. A formatted Excel attachment can now deliver each Qlik pivot table as a real Excel PivotTable, rebuilt from Qlik in every report, with Qlik’s layout, number formats and colours, and + and - buttons to expand and collapse each level. Turn it on per tab; the editor shows whether Excel will match Qlik’s totals. See Excel PivotTables in an attachment.

    Improvements

    • Wider columns in Excel PivotTables. Every value in a PivotTable built from Qlik fits its column when the file opens in Excel.
  8. v4.2.1

    KPImailer for Qlik Sense

    Fixes

    • Mail servers that are slow to answer. KPImailer now waits longer for the mail server to respond, so it can send through a server that takes several seconds to accept a connection instead of reporting a timeout.
    • Quicker answer from Send test email. A test email is tried once. If the mail server doesn’t respond, you see the result straight away instead of after several retries.
  9. v4.2.0

    KPImailer for Qlik Sense

    New features

    • Mail servers with their own certificate. Trust server certificate in the email settings lets KPImailer send through an internal mail server whose certificate cannot be checked, such as a self-signed one. Use it only for a mail server you trust. See Email / SMTP.

    Improvements

    • Clearer certificate errors. When a mail server’s certificate cannot be checked, the test email says so and explains what to do.
  10. v4.1.0

    KPImailer for Qlik Sense

    New features

    • Qlik pivots as Excel PivotTables. In an Excel template, a Qlik pivot table can be inserted as a real Excel PivotTable that is rebuilt from Qlik in every report, with Qlik’s layout, number formats and colours, and + and - buttons to expand and collapse each level. Before you insert it, the pane shows whether Excel will match Qlik’s totals for each measure. See Qlik pivots as Excel PivotTables.

    Fixes

    • Every permission fits on a role’s page. On smaller desktop screens the permissions of a row no longer run past the edge of the page; they continue on the next line.
  11. v4.0.0

    KPImailer for Qlik Sense

    New features

    • KPIBot, an AI analyst for your Qlik apps. Ask a question about your data in plain words and KPIBot reads your apps, calculates, compares periods and forecasts, then answers with text, tables and charts. It has its own workspace in KPImailer, opened from KPIBot in the sidebar or with Ctrl+.. If you want KPIBot and the AI features, contact Relevance. See Meet KPIBot.
    • Every figure shows where it comes from. Point at a figure in an answer to see the app, measure, period and selections it was read from, or how it was calculated. Each answer also lists its sources and the scope it covered. See Reading an answer.
    • Charts and tables drawn from your data. Answers can include charts and tables that open in a side panel and download as CSV, as Excel with a chart, or as a picture. See Charts, tables and downloads.
    • Bring your own files. Attach CSV, Excel, PDF files or images to a question, and KPIBot reads them alongside your Qlik data. See Attaching files and images.
    • Conversations you can come back to. Search, pin and rename your conversations, point a question at an app, a measure or a field with @, and pick the app to ask about. See Conversations, search and pins.
    • KPIBot remembers what you tell it. Say “remember that…” and KPIBot keeps it for every later conversation; review and edit your notes under What KPIBot remembers. See What KPIBot remembers.
    • Make it a report. Turn an answer into a report draft built from what the answer read, confirm it, and add a schedule. See Making a report from an answer.
    • Rate an answer. Mark an answer as good or bad and say what went wrong. Administrators review rated answers under Settings → KPIBot feedback and can teach KPIBot a correction about an app. See KPIBot feedback.
    • Questions across apps. Ask KPIBot about several apps at once. It first checks whether the apps belong to the same business (a shared company, product, customer or plant), then compares them side by side with each figure labelled by its app and the periods lined up, or tells you plainly that they are unrelated and reads nothing into their figures moving together. Asked what explains a change, it looks through your other apps and keeps only the related ones. Administrators choose how many apps KPIBot learns up front for each question under KPIBot tools. See Questions across apps.
    • Figures your apps have no measure for. Ask for a price weighted by the units sold, how many stores passed a threshold, the best machine of each month or a rate per product group, and KPIBot works out its own calculation from the app’s data and says which figures are its own and what they compute. Nothing is added to your Qlik app. See Asking a question.
    • Top lists, the rest and running totals in one answer. Ask for the best or worst few of each group with everything else together on one row, a breakdown by several fields at once, or running totals and moving averages for each member month after month, and KPIBot reads it in one go. A row for the rest says what it holds, and its prices and rates are its own. See Asking a question.
    • Teach KPIBot what is not in the data. Under Settings → KPIBot knowledge, administrators write instructions for every app (the currency, rounding, your company’s terms), instructions for each app, and facts about how an app’s data is recorded. They review the facts users taught KPIBot, approve them for emailed reports, correct or remove them, and can go back to any earlier version. See KPIBot knowledge.
    • KPIBot for people outside the main application. The new KPIBot user role signs people straight into KPIBot, limited to the apps an administrator chooses for them. KPIBot can also be given to any custom role. See KPIBot access.
    • AI analysis in reports. An AI Content cell answers a business question at run time from the app’s own data, with a footer that states what was read and where each figure comes from. Start from a template or write your own question. See AI content cells.
    • Bring your own AI model. Administrators connect KPImailer’s AI features to their own Azure AI Foundry or Anthropic account, test the key and pick the model. Web research and calculations at the provider can be switched on or off. See AI content settings.
    • AI usage and a monthly budget. See the tokens the AI features used each month, and set a monthly budget with a warning level. Administrators get an email and a banner at the warning level and at the budget; at the budget, KPIBot and reports with AI Content cells pause until the next month while every other report runs as usual. See AI usage and the monthly budget.
    • AI switched on app by app. Each app’s AI assistant is turned on in its settings, with a profile you can review: the time axis, the financial year, the business domains and the fields kept away from AI. See The AI profile.
    • Knowledge tailored to your business. A knowledge package prepared for your company teaches the AI features your own KPI definitions and terminology. Import it under Settings → Account & license → Tailor-made AI knowledge.

    Improvements

    • A clearer Roles page. Each role shows at a glance how much it reaches in each area. Its permissions are grouped by what they cover, each one says what it allows when you point at it, and the sensitive ones are marked. Find a permission by name, show only what a role grants, start a new role from a copy of an existing one, and keep your changes safe: KPImailer asks before you leave with unsaved changes. See Users & roles.
    • Removing an app from the repository removes everything stored for it, including its AI profile and what KPIBot was taught about it.
    • AI features on request. If you want KPIBot and the AI features, contact Relevance.
    • The KPImailer service starts more dependably on slower servers.
    • Restarting KPImailer releases its Qlik sessions straight away.

    Fixes

    • The dashboard fits a phone screen without scrolling sideways.
    • The page you asked for opens after an administrator changes your roles.
    • Signing in works straight away after a change to two-step verification.
    • The report editor’s top bar no longer overlaps the logo on smaller screens.
    • A failed sign-in keeps the e-mail address you typed, so only the password needs typing again.
  12. v3.20.0

    KPImailer for Qlik Sense

    Improvements

    • General performance and reliability improvements.
  13. v1.3.0

    KPImailer Portal

    Charts and tables in the email can now have their own choices, like files.

    New features

    • Own choices per visual. When a report’s author allows it, a chart or a table in the email can have its own values, for example last year in one chart while the rest of the email shows last month. Each one is listed under Visuals in the email with a small map of where it sits in the email. Needs KPImailer 3.19.0 or later on the instance. See Creating a report.
    • What a run used. A report’s history shows the values each run was sent with, for the report and for each visual and file with its own choices. See History.

    Improvements

    • Changed choices name the visual. When an author changes a report, a value set aside or no longer offered names the visual or the file it was for.
  14. v1.2.0

    KPImailer Portal

    The KPImailer On-Demand button in Qlik Sense can now take you straight to the reports of the app you are working in.

    New features

    • Open the catalog from Qlik Sense. The KPImailer On-Demand button opens the catalog on the reports of the app you came from, also through the sign-in. After upgrading, select Rebuild cache on each instance.
  15. v1.1.0

    KPImailer Portal

    Everything needed to move from the old KPImailer Portal, one server at a time, and a new report editor where a file of the email can have its own choices.

    New features

    • Give a file its own choices. When a report’s author allows it, each file in the email can use its own values, for example last year for the Excel file while the rest of the email shows last month. Every file starts as “Same as the report”; switch it to “Own choices” to pick its values. Sending a report once uses them too.
    • Bring your old Portal over. Administrators can connect the old KPImailer Portal and import its people with their current passwords, their roles and access, their servers and their address books. You review a plan of every item, with what happens to it and why, before anything is imported, and nothing is ever changed in the old Portal.
    • Move scheduled reports over, one server at a time. Administrators can plan the move of every scheduled report from the old Portal and its KPImailer server. The plan shows each report, what will happen to it and why, and how many emails a month the moved reports will send. You decide the few that need a choice. Moved reports are prepared switched off, so nothing is sent twice while the old server still runs, and nothing is changed on the old systems.
    • Switch the moved reports on, and back if needed. Once the old servers are stopped, administrators ask the KPImailer server to switch the moved reports on. The Portal first shows whether it can, and which old servers still need to be stopped. The KPImailer administrator reviews every report and approves the switch. Reports with a problem wait for their owner instead of sending. Within 30 days the switch can be undone, with a report of everything changed since.
    • The Migration fleet. One page shows every server being moved from the old Portal: how far each one has come, its numbers, and the step that comes next. From there administrators mark a server live, which opens it to its users and emails each of them once: owners get their moved reports and what happened to each, and people who have not signed in for 90 days get a link to set a new password. A server can be recorded as rolled back or decommissioned from the same page, and once the last server is done the old Portal’s connection is removed by itself.
    • Watch each server after the switch-over. Every server that has switched over shows whether its reports have been sent exactly as scheduled since then, with no send missed or sent twice and nothing sent by the old server, and when it has run cleanly for 14 days. A server that needs a look stands out in red.

    Improvements

    • A new report editor. Creating, changing or fixing a report now happens on one page: the name and email subject, your choices, the recipients and the schedule are all in view, each with a short summary and what still needs you. There are no more steps to click through. Your report is checked as you go and any problem shows right where it is. On phones, lists open from the bottom of the screen and the editor works in landscape too.
    • Search in every list. Every drop-down list in the Portal now has a search box, and long lists scroll, so you can type a day, a value or a name instead of hunting for it.
    • See your reports before they move over. Reports being moved from the old Portal show in My reports as migrating, with what happens to each at the switch-over: it starts sending, arrives paused, or waits for you to check it, and why.
    • Clear reasons on a moved report that needs you. When a moved report waits for you, My reports says exactly why, for example that its old schedule ran too often or that it was rebuilt from the old Portal alone.
    • Plan the move again after late changes. When a prepared report changes on the old server or in the old Portal before the switch, a new plan updates the prepared report, asks before replacing one that was changed since, and offers to remove one whose original is gone.
    • Clear guidance when a report’s author changes its choices. My reports now tells you when a change to a report affects one of yours, and the editor shows which of your choices no longer fit, which of your earlier values were kept aside, and what to do to get the report sending again. A value that belonged to one file says which file.

    Fixes

    • Saving a new report, sending a report once and copying a report no longer fail with a message about a missing key.
    • A report that its author publishes again can be opened and set up straight away, instead of showing “not found” for up to a minute.
    • When a report’s author changes its choices while you are saving, the Portal now says so and tells you to open the report again, instead of showing a general conflict message.
    • The installer no longer accepts an install folder given without its full path.
  16. v1.10.1

    KPImailer for Power BI

    Fixes

    • A run can no longer stay “Running” forever. If the KPImailer service was stopped or the server rebooted while a report was running - a Windows Update restart was enough - the run stayed marked Running indefinitely. Because KPImailer never starts a second run of a report while one is in progress, every later scheduled run of that report was silently skipped, a manual run was refused with “Another execution is already running”, and the run could not be cancelled from the UI either. Three things now guarantee this cannot happen:

      • When the service starts, any run left over from before the restart is closed as failed with the reason “The service stopped while this run was in progress”, and the report is free to run again at once. A scheduled run that was interrupted is run again after the restart.
      • When the service is stopped normally, a run in progress records itself as interrupted instead of being cut off mid-render.
      • A watchdog closes any run that has stayed open for an hour beyond the maximum execution duration without producing a result, so even a run stuck on something outside KPImailer is cleared.

      Each closure is written to the run’s event log and triggers the report’s on-failure alerts, so nobody has to discover it by noticing the silence.

    • Cancel from the run’s own page. The execution details page now has a Cancel Execution button for anyone who can manage executions. It stops a run that is in progress, and it also closes a run that shows Running but has no worker behind it. Cancellations are recorded in the audit log with who asked for them.

    • A cancelled run stays cancelled. A run that was cancelled or closed while its worker was still rendering can no longer overwrite that verdict and deliver its email anyway.

    Improvements

    • Duration counts from when the run actually started, not from when it was queued, so a run that waited behind others no longer looks slower than it was.
    • Long bursting runs are safe from being started twice. A run that took longer than thirty minutes could, in rare cases, be picked up a second time by the background job system while the first was still going. That can no longer happen.
    • The service is given time to stop cleanly. Stopping the KPImailer service now allows a run in progress to record itself as interrupted before the process is ended.
  17. v1.10.0

    KPImailer for Power BI

    Improvements

    • A hidden section no longer leaves a blank gap. When a section condition evaluates false, the email used to keep an empty band exactly where the hidden content had been. The body now closes that space: the content below the section moves up, rows that held only hidden content are removed, and the email gets shorter by exactly that amount. Blank spacing you deliberately left on the canvas is respected - only the space a hidden section vacates is reclaimed. The Attach body as PDF attachment and the editor’s preview reflow the same way, since all three render from the same layout.

    Fixes

    • PowerPoint attachments on Pro / shared workspaces. A .pptx attachment needed Power BI’s native export API, so on a workspace without dedicated capacity the run failed with an export error while CSV, Excel and PDF kept working. The browser render now produces PowerPoint too: each report page is captured at full size and becomes one 16:9 slide, matching what Power BI’s own PowerPoint export produces by default. The same fallback also steps in on dedicated capacity when Power BI rejects a native PowerPoint export at run time.
  18. v1.9.0

    KPImailer for Power BI

    Improvements

    • A lapsed license no longer locks the app. When a trial or licence runs out, KPImailer now behaves like its Qlik sibling: the app stays fully usable, a banner explains that report sending is paused, and sending resumes by itself once the licence is renewed on Administration → License. Only a never-registered installation is taken to the licence setup screen.

    • Test send now rehearses the real run. On a bursting report, test send fans out exactly as the scheduled run will - one copy per cycle value, each filtered to its value with {{burst.value}} resolved in the subject, body and file names - but every copy goes to the one address you typed, never to the report’s recipients. Test sends also honour Attach body as PDF, so what lands in your inbox is precisely what a recipient would get.

    • Failures now tell you what failed. Preview and test send used to answer every problem with the same sentence (“Failed to render the preview email”). They now name the actual cause - which filter clause was rejected and why, or which attachment could not be produced - in the preview panel, the run’s history and the alert email.

    • A skipped run is presented as a skip, not an error. When a report’s condition decides there is nothing worth sending, Preview now says “Nothing to send” with the condition’s result, instead of reporting a failure.

    • Not In works everywhere. The Not In filter operator is now applied to the email body, the attachments and the exported files alike.

    • Filters on date columns. A discrete-value filter can now target a date or date/time column directly.

    Fixes

    • Filters on number columns work. A discrete-value filter on a whole-number, decimal or true/false column failed every run with “The report filter set is invalid”. Filters of every column type now validate and apply correctly - to the email body, the attachments and the exports.

    • PDF and PowerPoint attachments on Premium Per User workspaces. Power BI’s export API refuses Premium-Per-User workspaces even though they report as dedicated capacity. KPImailer now recognises this: PDF attachments fall back to the browser render and still arrive, and a PowerPoint attachment explains the capacity requirement instead of failing cryptically.

    • File-name templates are kept. A typed attachment file name is no longer discarded when you later change the attachment’s scope, table or format.

    • Alert rule edits stick. Editing an alert rule while the page refreshed in the background could silently revert some of the fields you had typed - a renamed rule kept firing under its old name. Edits are now kept exactly as typed, and alert history records a delivery as sent only when it was actually handed to the email provider.

  19. v1.8.0

    KPImailer for Power BI

    New features

    • Manage Power BI behaviour from the admin UI. Everything that used to live in configuration files is now on the Power BI tab of System settings, seeded with sensible defaults you can edit in place. That includes the browser-fallback render controls used on Pro / shared capacity (page and inline sizes, capture scale factors, and page-load / target-resolution / stabilization timeouts), the delegated OAuth sign-in state lifetime, and the validation timeout. No more editing files to tune Power BI - change a value, save, and it takes effect.

    Improvements

    • Schedules can’t be activated until they’re ready. A schedule now only activates once its report and the Power BI connection behind it are both validated. This stops a schedule going live against a report that can’t actually be exported. The two checks are on by default and can be relaxed under System settings → Power BI → Validation. See Schedules and activation.

    • Run limits are now enforced. The per-run recipient cap and the maximum execution duration (both on System settings → Execution) are enforced during a run: a run that would exceed the recipient cap fails with a clear message instead of sending a partial batch, and a run that overruns its time limit is cancelled cleanly rather than hanging.

    • Power BI validation respects a timeout. Connection and report validation now honour the configured validation timeout, so a slow or unreachable Power BI tenant fails fast with a clear result instead of stalling.

    Fixes

    • Artifact retention cleanup no longer fails. Cleaning up old report artifacts could previously fail when an artifact was still linked to a sent email. Retention now removes the linked records correctly, so scheduled cleanup runs to completion.

    • Email links use your configured address everywhere. Password-reset, invitation, email-verification, and Microsoft sign-in links now all use the public frontend address you set under System settings → Email, so links work correctly behind a reverse proxy or on a custom host.

    • Delegated Power BI sign-in returns to the right place. The delegated OAuth redirect is now built from your configured frontend origin, so browser sign-in completes correctly across different deployment hosts.

    • Installer upgrades are safer. Upgrades reuse the ports you chose during the original install, and a rolled-back upgrade no longer wipes the database.

    • Additional reliability fixes to report render timeouts, execution cancellation, and the license-setup status display.