by Kevin Balentine | Jan 30, 2020 | Data Analytics, Front Page, News & Events, Press Release, Training and Development
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...
by Trey Smith | Jan 7, 2020 | Data Analytics, Front Page
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...
by Trey Smith | Dec 10, 2019 | 101 Things, Data Analytics, Front Page
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...
by Philip Duplisey | Nov 19, 2019 | Anomaly Detection, Business, Data Analytics, Data Science, Front Page, Machine Learning, Time Series Forecasting
By Philip Duplisey VP – Strategy and Business Development I recently shared my excitement for a reliable new automated forecasting solution. Everyone needs it, and producing a plan is a fundamental part of every line manager’s job function. It can also be...
by Trey Smith | Oct 22, 2019 | 101 Things, Data Analytics, Front Page
One thing which would have been useful years ago was knowing I could copy data directly from Excel into the load script for an Inline Load if I changed the delimiter setting in the load script. So what this means is you can copy a data set from Excel: Paste into Qlik...
by Trey Smith | Oct 17, 2019 | 101 Things, Data Analytics, Front Page
You might have noticed I used this in the last example. AutoGenerate is so useful and has so many use cases. I probably use this in every app I create: from empty stub tables, generating a new field using another’s unique values, or as a way to log different steps...
