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.
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,