Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView How To (or Tips & Tricks) Application

Employee
Employee

QlikView How To (or Tips & Tricks) Application

Some time ago I began an application designed to work as a general "How To" or "Tips & Tricks" document for QlikView developers. Up until now (9/12/2013) I have not made it available on community, which is something I should have done a long time ago. It covers all sorts of topics, such as Mapping, Comparative Analysis, Set Analysis, Working with Dates, Forecasting, Macros, etc. A couple of screen shots are shown below.

Note that if you are using QlikView Personal Edition you CAN still open this application, as it has an embedded licence. For those who want to reload the app, the data files and images are contained in the attached zip file.

I hope you find it useful!

Screenshot1.jpg

Screenshot2.jpg

Attachments
Comments
Not applicable

Excellent job: thank you very much for sharing it.

Things are well explained and can be reused (I certainly will reuse the map part)

Fabrice

0 Likes
Not applicable

Really good work and easy to follow.  Thanks for making this available.

Julian

0 Likes
marcus_malinow
Valued Contributor III

Lee, this is great! I'm sure that I'll be referring to this in the future.

0 Likes
carbal1952
Contributor II

I'm translating into Spanish, adapting and recreating it to use it as a tutorial or guide.

Thanks again.

CB.

0 Likes
michael_gardner
Contributor III

I can't wait to add the Quick Report to my own Applications!

0 Likes
Not applicable

Thanks a lot for sharing this, this is Christmas gift for us

0 Likes
paul_tuyls
New Contributor III

Great, should be one of the samples when you download Qlikview for the first time !!

Thanks

0 Likes
Employee
Employee

Great asset. Thanks for sharing.

Quick Question - on the Quick Report sheet > State is not appearing with appropriate calculations. Is this expected?

Thanks.

0 Likes
Employee
Employee

Hi Greg.

Well picked up. That was actually the change I thought I recently updated. When loading the list of fields from spreadsheet I forgot to place [] around the fields with spaces in them, of which State / Province was one. I have fixed this and uploaded the corrected QVW file. Thanks for pointing this out.

Regards

Lee

heimo_ernst_wei
New Contributor III

Great work! Thank you.

However I was running into problems as there is a minor bug in the script-code:

The loading of the Excel-sheets does not work as the reference to them is made like:

FROM

datafiles\QuickChart.xlsx

(ooxml, embedded labels, table is Dimensions);

instead of:

...

FROM

$(vPathDataFiles)QuickChart.xlsx

(ooxml, embedded labels, table is Dimensions);

This applies to the tabs "QuickChart" and "Glossary" in the script.

Regards Heimo

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎12-08-2013 11:56 PM
Updated by:
Employee