Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

Configuration File

jmvilaplanap
Valued Contributor

Configuration File

Hi,

I developed this configuration file with macros, to had a first steep to begin a new QV Project.

It has this sections:

  • Expressions
    • To create expressions and load it as variables in the QV document
  • Variables
    • In fact is the same that the previous point, but logically splited
  • Colors
    • You can "create" colors using Hex or RGB atributes and use it later in QV, it works as variables but you can colorize the cells of the excel sheet to see the result
    • In the "version 2" I've added the possibility of colors with transparencies but in Excel is not possible to show it.
  • Normalization
    • This section is made to rename fields, you can open a QVD loaded directly from the source to take the original names, change it and reload again for change the names in the QVD
  • Localization
    • This section is for create our dashboards with multiple languages
  • Security
    • For the section access
  • ConnectionStrings
    • To store the connection strings
  • Set Analysis Generator
    • To create simple set analysis expressions, you can copy it to the expressions sheets
  • Scripts
    • Here are the snippets with the code to use this "features" in our script

There is a lot of things to improve in this macros, all the ideas will be welcome, and if you want to use it... feel free to do it.

Attachments
Version history
Revision #:
1 of 1
Last update:
‎2017-06-28 08:11 AM
Updated by: