973-584-9100 contactus@bardess.com
83 – Over-Engineering

83 – Over-Engineering

You should keep in mind that just because you can do something, doesn’t necessarily mean you should. Try and be aware of the actual value something will provide. If it takes you 40 hours to automate something that is done manually for 5 minutes every month, it would...
84 – Executing Generated Script

84 – Executing Generated Script

This concept can be used in so many ways and can come in handy for complex situations. Essentially, with the use of dollar sign expansion, you can execute script you have programmatically built in the script or pulled in from source files. Notice...
86 – Preceding Load

86 – Preceding Load

Preceding Load allows you to perform additional load steps before initializing a table. Each step uses the output of the preceding load statement as input. Example: Source In my opinion, the biggest benefit of using this is code readability. There may be times where...
87 – Qlik Community

87 – Qlik Community

We all use Qlik Community as a resource. If you don’t, it’d be a lot cooler if you did… I was a long time lurker, however recently in the past year I’ve started to contribute. And I gotta say, it has been a blast. I highly recommend contributing. It may not be...
88 – Renaming Fields

88 – Renaming Fields

This is a cool little trick that I use a lot because of preference. The idea is that you can rename all the fields within your Qlik application using one statement, two if you count prep work. Script: Source Result: Documentation I tend to use this so that the fields...
}