Qlik Sense: Using Fuzzy Searches

With Qlik Sense, you can now search Records to find data that matches, or kind of matches, a search criteria. This is known as fuzzy searching.  A fuzzy search compares the original searched string to each record and determines its degree of resemblance.  The results of these searches are ordered in degree of resemblance order.…

Read More

QlikView: Using a Trigger to Set a Default Selection

By setting a default selection on a document or sheet, such as year or month, is an easy way to control the initial starting point when a user logs in. Providing defaults is essential as it will help to narrow the view and provide a focused lens to aid the user as they begin their…

Read More

Year-to-date report? Try the FR Match function!

Viewing current period vs. quarter-to-date vs. year-to-date is a common layout used in financial reports.   Often this layout is managed using substitution variables that automatically pass in the current period / QTD / YTD members.   Or you could use range functions with hidden columns to retrieve additional periods and then sum them up for presentation…

Read More

Hyperion and Windows 10 Compatibility

Since Windows 7 and 8.0 have both reached the end of mainstream support and the rest of Windows 8.x is slated to reach end of support January 2018, many IT departments are starting to evaluate Windows 10 as a new Enterprise standard.  With Windows 10 comes Microsoft’s newest version of Internet Explorer, Microsoft Edge.  While Microsoft…

Read More

Hyperion Smart View – Essbase Shared Connection Changing or Vanishing

We have seen a few instances lately where some odd Smart View Essbase Shared Connection behavior has been popping up in version 11.1.2.1. In short, most administrators prefer that there be one Essbase server linked to the Essbase connections in a Smartview Shared Connection. However, an issue has been experienced where other servers in related environments…

Read More