Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView How To (or Tips & Tricks) Application

lms
Contributor III

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

Not applicable

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

Julian

marcus_malinow
Valued Contributor III

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

carbal1952
Contributor II

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

Thanks again.

CB.

michael_gardner
Contributor III

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

Not applicable

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

paul_tuyls
New Contributor III

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

Thanks

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.

lms
Contributor III

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

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