Qlik Sense September 2018 has arrived!

[QlikSenseUpdates]

We are excited to share news on the September 2018 release of Qlik Sense, and would like to highlight some of the key enhancements in this release. Since the June 2018 Release, we have received overwhelmingly positive feedback on the value of Insight Advisor, and how it suggests the best analytics and insights to explore.  Qlik remains focused on Augmented Intelligence and the September 2018 Release expands the use of Insight Advisor to published Qlik Sense Apps, to encourage further data exploration across the enterprise.  This is only the beginning of how Qlik will reshape the analytics community with the power of our Cognitive Engine, with more to come around AI in future releases! In addition, we are furthering our commitment to delivering ‘QlikView like’ features in Qlik Sense with our focus on Advanced Authoring.  The September 2018 release offers additional advanced authoring capabilities that enable customers to build sophisticated data layouts while improving the speed of application development through ease of use.  These include: Better control over information density within the Qlik Sense client for devices that support touch and mouse input Default bookmarks for setting initial selection state when applications are opened The ability to turn off responsiveness of the client for custom sheet sizing Expression Editor enhancements including direct links to help, restructured function categorization and improved search capabilities Visualization control improvements including conditional show/hide in pivot tables and customizable master measures

We are excited to announce another high-value enhancement delivering a key customer requirement. The September 2018 Release offers the ability to move multiple apps from stream to stream which removes the previous limitations from the Qlik Management Console (QMC).  Further, we have made investments to improve performance and stability with upgrades to our open source front-end framework. The September 2018 Release will also deliver enhanced mapping capabilities including a new Density Map Layer that is very useful when mapping data on a highly localized and detailed level.    The Density Map Layer is a multi-color gradient background where the color intensity depends on the weight and closeness of points.  This map layer is useful for mapping data such as: crime statistics, house values, etc.  The release does not stop there as we have made other general mapping improvements around additional controls and data inputs. For value-added products, we’ve strengthened the capabilities of Qlik NPrinting around administration, expanded authoring, and improved security for report consumption.  For example, you can now import users/roles from an LDAP source and, if desired, you can substitute the TLS Cipher suite.  In addition, Qlik NPrinting now has session expiration log out, output of reports in .xlsm formats, and report level password protection.  We continue to expand connectivity with the addition of Microsoft Azure DB and Jira connectors, while also delivering enhanced security with LDAP authentication within the integrated connector to Presto. More to come later this month on additional SAP connectors! And last, the September 2018 release addresses the mobile security requirements of large enterprise deployments, delivering full support for AirWatch EMM. As AirWatch is among the fastest growing EMM vendors, it is critical for Qlik in becoming a tier one vendor to integrate well with and support this platform!  The much-anticipated Qlik Associative Big Data Index is to be released later this month via a new Early Access Program (EAP).  Look out for more information in the coming days. Watch the What's New video to see these awesome features in action: What's New in Qlik Sense September 2018 Can't see the video? YouTube blocked by your region or organization? Download the .mp4 attached to this post to watch on your computer or mobile device. Resources: To download, please login first under https://qlikid.qlik.com/signin and then click here! Qlik Sense September 2018 Help

[AlexOmetis]

jdiaz‌ - if you have an auto calendar or another master calendar then you should be able to select "Today" in there as a field value and set a bookmark on that. Having a good calendar with usable shortcuts like that helps your end users not just the default bookmark functionality.

Of course, you can make a great calendar with shortcuts likethat at https://www.ometistoolkit.com/timeawarecalendar

[ChristofSchwarz]

Thats actually not correct, Jose Diaz. A formula can be used as a selection and if you create a (default) bookmark after that, the formula rather than the hits will be remembered. In your case =Max(Month) is a wrong thought. If you start with a "=" you have to provide a full formula including the field name on which you operate. Assuming that should work on a field "OrderMonth" then the selection would be "=OrderMonth=Max(OrderMonth)" ... your formla just returns a value with no comparision to the field, which results in all member of the field to be selected

-bye

[Michael_Tarallo]

Hello Lanevich - that link is for Qlik partners and customer only - if you are not one of those - you can download Qlik Sense Desktop  or register and login to Qlik Sense Cloud here: https://www.qlik.com/us/try-or-buy

Let us know how you do!

Regards,

Mike T

Qlik

[diagonjope]

Hi Christof,

Thanks for your comment.  I stand corrected: it does work.

Cheers,

--José

[diagonjope]

Thank you Alex.  We want to create a default bookmark for the last couple of years.  As mentioned by Christof, the expression that I used in my original posting was incorrect (but it wasn't the one we were actually trying to use, it was just an incorrect example - the correct version of what we wanted to do was something like "=MyYear>=$(=max(MyYear)-1)").

Cheers,

--José

[diagonjope]

csw‌,

Sorry to bother you again with this, but I seem to be having problems creating the bookmark expression when I try to create the bookmark on a field derived by the autoCalendar, such as in the following expression:

=BUDAT.autoCalendar.Year>=$(=max(BUDAT.autoCalendar.Year)-1)

The expression works fine when I try to do the same with a regular field loaded from a table.  Any thoughts?

Something else is that if we define a Dimension for BUDAT.autoCalendar.Year, say MyYear, we can't refer to the Dimension name in the expression typed in the search box for a drop list for this Dimension: we have to use the fully derived name of the field.  But I guess that is a separate matter.

Cheers,

--José

[vkish16161]

Try creating a flag from the backend.

You can create a small snowflake table that associates with your year in the Fact table.

[ChristofSchwarz]

Hi Jose. Making a Year-1 is a bit more tricky since the value behind the *.autoCalendar.Year is a Dual() value where the numeric part is the Jan-1st of the Year: 2018 is infact 43101, 2017 is 42736 ... so the formula may work fine in a set analysis, where the textual part is relevant, but for a number operation to match, your Max(*.autoCalendar.Year)-1 returns the 31-Dec of the prev year, not the Jan 1-st which would be needed. As suggested by other users here, I would calculate a simple flag in the script that gets you the last two years. If you still want to do this with formula in the frontend it would be:

=SomeDate.autoCalendar.Year>=$(=Num(AddMonths(Max(SomeDate.autoCalendar.Year),-12)))

[diagonjope]

Thanks!  I really appreciate your help with this.

Cheers,

--José

[macaruso]

Hi, good afternoon.

I wanted to ask why Qlik Sense Desktop does not have the possibility of always keeping a selected value in the filter panel, when in the version of Qlik Sense Cloud it is possible.

Regards,

Martín.