78 – AutoNumber

78 – AutoNumber

To follow up on my cardinality post, a very useful function is AutoNumber. AutoNumber will create an integer for each distinct value in your defined namespace, which is usually a field. The second parameter, allows you to define the namespace, which means you can use...

read more
79 – Cardinality

79 – Cardinality

One of the key things to understand when trying to tune a Qlik app for performance is understanding the innerworkings. If you haven’t done so already, I very strongly suggest you read Henric’s blog Symbol Tables and Bit-Stuffed Pointers which goes into detail on how...

read more
80 – Do While

80 – Do While

Most loops you will see are For loops. These are great if you can programmatically determine the number of loops you need to do. For example the number of rows of a table. However, what if you need to loop as long as it takes to finish? You don’t know how long it will...

read more
81 – ApplyMap

81 – ApplyMap

This is a post that might be common knowledge to you, but if not this can be a crucial addition to your workflow. ApplyMap is a function that is very similar to VLookup in Excel. Essentially you can utilize a mapping table that you can bulk find and replace, provide...

read more
The TIM Free Trial: Sign Up Today

The TIM Free Trial: Sign Up Today

Learn More: WebinarsGet forecasts in seconds using TIM from Tangent WorksClick to Download TIM™ Datasheet Introducing TIM from Tangent Works, the easy to use, accurate automated forecasting solution with a fast, seamless user experience that will save you time and...

read more
82 – Placeholder Tables

82 – Placeholder Tables

You might have noticed me using these in a few of the previous examples. The idea is that you create an empty table that you can concatenate to. The number one reason I do this is to be explicit. I know Qlik can and will auto-concatenate, but I want to be extremely...

read more
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...

read more
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 "$(vAnswer)" in the...

read more
85 – Loading Entire File Content

85 – Loading Entire File Content

Have you ever wanted to consume a whole file’s content into Qlik as a single value? Perhaps, a series of README files or code files which can be shown on the front end? This is a little tricky since Qlik was really built to consume tabular data. So when connecting to...

read more
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...

read more
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...

read more
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...

read more
89 – Qlik Sense Ports

89 – Qlik Sense Ports

Qlik has great documentation, however it is a bit cumbersome when it talks about networking. Below are the ports needed. Also, you need to create an inbound and outbound rule. Here is a tutorial. It is much less complicated than it sounds. Ps. I am not covering HTTP...

read more

Why choose Bardess?

    • We transform data into insights and action, everyday.
    • We only hire the best talent. Our senior professionals have functional and industry experience so you can trust their advice.
    • We deliver cost effective services with a tangible ROI.
    • A level of unmatched flexibility in the industry.
    • The Bardess LEAP.
    • Our clients consistently discover real business value in our consulting service.
    • We have a proven track record of success with major clients.
Client List

Contact Bardess

3 + 10 =

Main Office

U.S. Headquarters
477 State Route 10, Suite 208
Randolph, NJ 07869

 
 Bardess Canada ULC

100 King St. West, Suite 5600
Toronto, ON M5X 1C9

Email Us

Bardess, the Bardess logo, Zero2Hero, z2H and Text2Viz are trademarks or registered trademarks of the Bardess Group, Ltd. All other marks are trademarks or registered trademarks of their respective holders.