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.
These QlikView examples are all still available, but you may also want to see our Qlik Examples page for some Sense applications also.
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.
Addendum:
Our site now has a more complete list of the QlikView apps that we have shared to Qlik Community, which can be found here:
https://www.quickintelligence.co.uk/examples/
I follow all of your Qlikview forum posts! They are awesome and extremely useful! Thank you! When are you gonna write a book :)
Really helpful.
Thanks
Hi,
I have fiscalyear cloumn like-> 2014Q1
Now i want to change fiscalcoum like-> FY14
i used mid functon but no luck
please help us thank u
You can do a substring like this:
‘FY’ & mid(financialyear, 3, 2) as financialyear
Hope that helps.
Hi Steve,
I tried your ‘FY’ & mid(financialyear, 3, 2) as financialyear
but iam getting
FY14
FY
FY14
like this
Plese help
It looks like you have missing or blank values in your financial year field. You may need something like:
if(financialyear <> ” and not isnull(financialyear), ‘FY’ & mid(financialyear, 3, 2), null()) as financialyear,
great examples of thinking creatively to improve user experience
Many thanks – glad you like them. There are now some newer documents up on QlikCommunity and I fully intend to be adding more soon.
This is indeed. Very useful. Thanks for update. I have one requirement where I want to show scatter plot but with magic quadrant. While one can manipulate axes and static values, what I want to know is can we flip or reverse the axis in Qlik View?
Hi Nilesh,
I’m not quite sure what you are trying to achieve here. For a magic quadrant you would rate every point on a 0-100% scale, set a static max on both axis to 1 and then put reference lines on both axis at 0.5.
There are some things you can do with axis in QlikView, say you wanted 0 in the middle of a scatter and 0-10 on each axis, you can multiply values by -1 to put them on the flip side of the axis (this is useful for butterfly charts) but it is difficult to fully hide the minus symbol (the number format helps, but it still appears on hover or export).
Hope that helps with your question?