QlikNews: ProductView

QlikView 8.5 Preview

Below is a quick overview of expanded capabilities and benefits with QlikView 8.5, to be released June 30. For deeper insight into the more than 85 new features packed into QlikView 8.5, contact your QlikView sales representative.

Enterprise Deployment/Integration

QlikView 8.5 provides a more holistic view of enterprise deployments, simplifies management tasks and integration with third party software, including J2EE server applications. External applications can control and update QlikView Server deployment and applications can be monitored with third-party tools. IT administrators can track and asses utilization history of QlikView Publisher and Server for system optimization.

Mass Deployment Clients

QlikView 8.5 enables simple, secure deployment of large numbers of QlikView documents to large numbers of users. Emphasis is on putting personalized analysis into the hands of the right user at the right time. Numerous feature enhancements for AJAX and Java clients improve performance parity across client types, providing near C++ levels of interactivity and capabilities to deploy QlikView to large numbers of users in seconds. This includes simplified QlikView deployment in Java environments such as Linux and Sun Solaris, and rich mashups for visual integrations with common web services like Google maps and Microsoft Virtual Earth.

End-User Experience

QlikView 8.5 extends focus on making analysis useful, beautiful and providing users with data views that they want to use. End users can show live QlikView objects in office applications such as PowerPoint, Word and Excel. In our continuing drive for new innovation, we introduce Set Analysis, which is a next generation of QlikView in-memory associative technology, in 8.5. Set Analysis enables users to compare two or more selected states at once, “lock” or “chose” selected states for comparison, show multiple states without coding into load script, and extend the power of QlikView bookmarks. Additional features make it much easier to resolve hierarchies in data structures such as product hierarchies and organizational structures. QlikView is more beautiful than ever to see and use!

Simplified Licensing

With QlikView 8.5, we’ve made licensing easier to understand for customers in an effort to provide more analysis power to more end users and fully utilize next-generation hardware platforms. The product distinction between 32- and 64-bit QlikView and QlikView server has been removed. All QlikView users now have the choice to use the full power of 64-bit QlikView. In addition, QlikView 8.5 will allow server object creation (“server collaboration”) from QlikView Analyzer instead of requiring QlikView Professional. The overriding benefit is that it will be easier than ever to Simplify Analysis for Everyone in your organization.

QlikView Tips & Tricks

Here are more tips and tricks to make your day-to-day QlikView usage even simpler. Enjoy!

Do the equivalent of “In” in QlikView script using “match”

Want something simpler than stringing together a lot of “if Type=” code?

What won’t work is: Sum(if(Type in (‘A’,’B’,’C’,’D’),Qty))
What WILL work is: Sum(if(match(Type,’A’,’B’,’C’,’D’),Qty))
If you want “not in” then just change to: Sum(if(not match(Type,'A','B','C','D'),Qty))

Again, this is simpler than stringing together lots of ‘if Type=’A’ or Type=’B’ or Type=’C’ etc.

Want to split objects from QlikView multi-value fields?

Use ‘subfield’ to transform:

ID	Object
1	AB, BC, CD
2	AB, CD, EF

Into:

ID	ObjectSplit
1	AB
1	BC
1	CD
2	AB
2	CD
2	EF

Load ID: subfield(Object,',') as ObjectSplit FROM / SQL / RESIDENT

Conduct advanced search in list boxes and multi-boxes

Just press = with a list box or multi-box selected to do advanced searches, for example:

=sum(Sales)>500000

Improve security of sensitive data with QlikView's Scramble Function

If you ever need to send sensitive data, QlikView offers a built-in scramble function. QlikView scrambling will make the data impossible to read. The only way to retrieve the data is to reload it into the document. To scramble data:

Open QlikView Developer
Open the document and go to Settings » Document Properties » Scrambling Tab
Select the fields that are sensitive and press Scramble

*Please note that fields containing large numbers of data can take time to scramble.

Copy formatting with QlikView’s Format Painter

QlikView’s Format Painter button makes it possible to copy formatting from one sheet object to another or to many sheet objects. In order to copy formatting to a single object:

Click on the source object
Single-click on the format painter button
Click on the target object

In order to copy formatting to multiple objects:

Click on the source object
Double-click on the Format Painter button
Click on each of the target objects

*Stop the copying by again clicking on the Format Painter button or by pressing ESC

When you copy formatting between sheet objects of different types or when you click on the caption of the target object(s), only border and caption properties will be copied. When you copy between sheet objects of the same type, additional properties specific to the object type will be copied.