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
90 – Dual Data Type Caveat

90 – Dual Data Type Caveat

Dual combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes. Syntax: Caveat: Now when I think of the data type...

read more
Bardess Director Trey Smith to Speak at Qlik NYC Meetup

Bardess Director Trey Smith to Speak at Qlik NYC Meetup

Trey Smith, Bardess Director of Data Analytics, will team up with VizLib CEO Martin Mahler to talk about "Distributed Reload processing in Qlik" & "Enhancing Your User Experience." This meeting will happen Thursday, Feb. 27 at Qlik's offices in the Empire State...

read more
91 – Join Distinct

91 – Join Distinct

This is something that I found out the hard way. Qlik applies the DISTINCT keyword on the resulting dataset. So, when you join distinct table, you are not joining the distinct table to the other table. You are doing the join and then returning the distinct records...

read more
92 – Only

92 – Only

You'd probably be surprised that this is one of my most used functions within a dashboard. It is just such a cool function. Though, it is almost exclusively used for UI/UX functionality. Only() "Only" is an aggregation function that can be used on a string field. If a...

read more
93 – Test Cases

93 – Test Cases

I am a firm believer that boiling down a problem into its simplest form is the fastest way to solving it. I also think one of the fundamentals of programming is breaking a problem into a bunch of smaller problems. If you combine these together, you get test cases out...

read more
94 – Setup a Lab Environment

94 – Setup a Lab Environment

While it is great that Qlik offers a free desktop, I usually suggest trying to set up a server environment for local development. I personally run a Windows Server virtual machine (VM) with QSE installed, which I can access with my browser. I do it this way for three...

read more
Bardess Consultant, Customers Named Qlik Luminaries

Bardess Consultant, Customers Named Qlik Luminaries

RANDOLPH, NJ – Jan. 28, 2019 – Bardess Director of Data Analytics Trey Smith and customers at Verizon and Sterling National Bank have been named Qlik Luminaries for 2020. "I'm extremely excited for this opportunity to be a part of an amazing class of people,’ Trey...

read more
Introducing Customer Success at Bardess

Introducing Customer Success at Bardess

Time to value. ROI. Holding a competitive advantage. These are all indicators of success, however very few people have been able to realize these things alone. The vast majority of successful leaders have achieved excellence by surrounding themselves with a trusted,...

read more
Exporting Data From Qlik to Database

Exporting Data From Qlik to Database

Description This covers how to use Qlik to insert data from a Qlik table into a SQL database using script generation. This is done for all tables within a Qlik model where the Qlik and Database table and field names are the same. *There is no data type...

read more
95 – Variable Parameters

95 – Variable Parameters

In other words, user defined functions. With utilizing variable parameters, you can create your own functions touse later. For example, a function to calculate the number of weeks between two date fields: SET fWeekDiff = '(((Year($2)*52)+Week($2))) -...

read more
96 – Clear Your Variables

96 – Clear Your Variables

This is a very short and sweet one. Clear your variables. Trust me, it is worth it. It’s easy and will save you time debugging. To clear a variable just do: vVariable=; Also if you tend to copy apps as starting points, don't forget to delete old variables. The above...

read more
An Automated Forecast in Seconds

An Automated Forecast in Seconds

Get forecasts in seconds using TIM™ STUDIO Click 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 money. TIM integrates with BI...

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

10 + 13 =

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.