66 – Advanced Search in Set Analysis

66 – Advanced Search in Set Analysis

Set Analysis is extremely powerful, however it can seem a bit overwhelming at times. One thing I felt helped me further understand the mechanics is recognizing what will work within a filter search, will work within a Set Analysis condition between double quotes. For...

read more
67 – Create a Codebase

67 – Create a Codebase

One of the reasons I started doing this blog was to have a place to store my random Qlik info. But even before this, over the years I have collected a number of code snippets that I can refer to whenever a similar problem comes up. So you don’t need a blog, you just...

read more
68 – When to Upgrade

68 – When to Upgrade

With Qlik Sense having 5 releases a year, it can quickly become overwhelming staying up to date on the latest release. And even then, should you even be on the latest and greatest? Here is what I recommend as a rule of thumb: when upgrading or installing for the first...

read more
69 – Mixed Granularity

69 – Mixed Granularity

There will always be situations where the data you get isn’t at the same granularity as the other. The benefit of Qlik is you can leverage the associative model to account for these scenarios. Some instances will call for a link table, others a concatenated fact, but...

read more
Changes Coming to Qlik Sense Desktop June 30

Changes Coming to Qlik Sense Desktop June 30

Attention QlikSense Desktop Admins and Users! After 6/30/2020, you will be required to have a license in order to develop locally. Here's an instructional video for your preparation, from the Bardess Customer Success team. For more information, click here and here.

read more
70 – Pick Match

70 – Pick Match

One of the most resource intensive functions in a chart is the If statement. In a lot of scenarios, what you can do is leverage the combination of Pick and Match to replicate the functionality while increasing performance. Example If you need an Else condition, there...

read more
71 – Copy Paste

71 – Copy Paste

There’s nothing worse than waiting for a long reload to find out you made a typo. One thing I have made a habit of is copy and pasting script items: table names, field names, variables, etc… This is definitely a simple item, but it can save you a ton of time down the...

read more
72 – Dual Set Analysis

72 – Dual Set Analysis

By default you need to reference the display (read: string) value of a dual field in set analysis versus the numerical value. I personally think this is a weird behavior of Qlik, however it is what it is. The downside to this is that string operations are much slower...

read more
73 – Wildcard Load

73 – Wildcard Load

One good thing to know is that you can use an asterisk * within a file name. Qlik will load all the files that fit the criteria. Say you have a directory named QVD, which has all of your QVDs prepped and ready for your data model. You can simply do the following to...

read more
The 40-Day Appreciation Challenge

The 40-Day Appreciation Challenge

Bardess Group CEO Barbara Pound recently challenged the world to join her on a 40-Day Appreciation Challenge. The response has been amazing, as many people are joining her in the challenge and posting videos or text posts to share what they are appreciative of and...

read more
74 – SubField

74 – SubField

If you are like me, you probably use SubField a lot. I had used it for years before I stumbled across one of its most powerful features in someone else’s code. If you do not provide the position parameter, it will expand a record for each delimited value. I’ve worked...

read more
75 – Arrays

75 – Arrays

Arrays and/or Lists are very common in programming languages. In Qlik scripting there are two ways to go about creating an array of sorts. The first way is storing a list in a variable: The second way is by using a field: Source Result: The main use of these will be...

read more
76 – Remove Unused Fields

76 – Remove Unused Fields

I can’t tell you how many times a client has said to leave a field in the data model just in case they want to use it later. Just don’t do it. Take it out now, if they want to use it later, then bring it in later. You can easily set up the app so that it is a super...

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

14 + 3 =

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.