The QlikCommunity is a fantastic resource for QlikView developers and users alike. It allows members to post questions and get quick results relating to anything to do with QlikView.
I contribute whenever I can to this forum, providing solutions to users development issues. Sometimes descriptions are not enough and the best way to help is to upload a working example. That is one of the reasons QlikCommunity has a Shared QlikViews section.
Here are some links to some of the QlikViews I have uploaded in order to provide assistance on the message boards. All can be downloaded and code used in your own QlikView documents.
Simple Set Analysis Example
This is an illustration of how to use the set analysis syntax in QlikView to do a simple prior year comparison.
Prior Period Comparisons
A working example of a full prior period analysis. This app has a dynamic year to date and month to date comparing to prior year, prior month and same month prior year. I have used similar code to this on many live implementations.
Show and Hide Windows
The question was asked if there was a way to expand objects, such as charts, better than the native maximize feature. The solution was two copies of each chart – each with Conditional Show set on them. To toggle Show and Hide actions were placed on buttons.
Set Date Variables with Buttons
Often variables are better than date islands for timed based expressions – particularly when used in conjunction with Set Analysis. This example shows how date variables can be modified with button clicks, moving days or months at a time.
Chart with a Dynamic Date Dimension
Dive to detail for dates can be achieved with a drill group. However, these don’t allow you to show the end of one period along with the start of another. This dynamic approach, using a calculated date dimension, adapts to your current selections to show the most appropriate values.
Alternative Current Selections View
Often QlikView documents can lose valuable display space to a large current selections box on each tab. An alternative to this is shown in this example – all selections are shown in a tidy text box which expands as required (on being clicked) to show a full current selections box.
There are further examples that can be found via my profile on QlikCommunity. New ones will be added in time – follow @quintelligence on Twitter to be notified when they appear. I hope that some of these examples are useful to you.
Our site now has a more complete list of the QlikView apps that we have shared to Qlik Community, which can be found here: