This September, we're turning the spotlight on a true Qlik pioneer whose expertise and passion have shaped the community in remarkable ways! Meet Mark de Souza Costa, a Qlik virtuoso with a rich 15-year history of mastering complex ETL solutions, enhancing application performance, and driving innovative integrations. From his roots in Brazil’s IT scene to leading the charge in Qlik innovation, Mark has been a relentless force for progress.

His journey is packed with insights and dedication, and we're excited to share his story with you. Let's dive into Mark’s Qlik adventure in his own words!

"I'm a firm believer that the best way to learn is by sharing knowledge. This belief drives me to contribute actively to our Qlik Community and Qlik Meetup Groups. Together with my colleague Igor Alcantara, I manage four Meetup groups across the US: Atlanta, Boston, Dallas, and Portland. We also support others who are interested in starting their own Meetup groups. Additionally, we maintain a blog and a YouTube channel, both under the name 'Data Voyagers,' where we share insights about Qlik."

When he's not diving deep into the world of Qlik, Mark enjoys playing video games and exploring his passions for videography and audio recording. His enthusiasm for learning and trying new things is truly inspiring.

Please join us in congratulating Mark on his incredible contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Mark, for your commitment and passion. @marksouzacosta @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa

Hi all - 

I wondering if i could collate some recommendation for a full load. I appear to be getting a disconnect from the DB issue, that restarts the full load each time. I haven't set the logs to verbose just yet to see whats happening. But what I do know the tables loading are in the 10s of billions for records size.

I am wondering if given that records count there might be something obvious I may need to set to stop this happening. It should be noted its taking about 5 hours per billion records.

thanks.

Hello Qlik Community!

I noticed there are not a lot of resources that shows how to use the Real-Time API for AutoML inside a Qlik app UI. I then recorded a video showing different ways to perform this.

This is the article. If you like, please share and leave a comment on Youtube.

https://www.youtube.com/watch?v=0u1MCW0bA8c

In our Qlik Sense Enterprise on Windows environment we are using Analyzer Capacity license for most users (i.e users consuming minutes when using Qlik Sense), and we have a restricted amount of users who are assigned a dedicated Analyzer Access license (i.e they can use Qlik Sense as much as they want).

In the monitoring apps we can identify the "capacity users" consuming the highest amount of minutes, so that we can assign them a dedicated Analyzer Access license if we want to.

But we would like to calculate how many minutes the dedicated Analyzer Access users would have used each month, had they still been Analyzer Capacity users. The monitoring apps show us the number of sessions for each Analyzer Access user, but we can't compare their usage to the Analyzer Capacity users' usage, so we can't know for sure if we should move some of the Analyzer Access users back to the Capacity license (something we would want to do if they won't consume many minutes anymore).

Is it possible to calculate consumed minutes for Analyzer Access users, as if they were using the Analyzer Capacity license?

Hi,

I imported Semantic UI into my extension project but I noticed an error in the console. This error appeared when I updated the version of qlik sense enterprise to may 2024 patch3. Did this happen to you too?

define( [ "qlik",

        "jquery",

        "css!./style/style.css",

        "css!./style/semantic.min.css",

        "./style/semantic"

    ],

    function ( qlik, $, style, cssSemantic, jsSemantic)

{

    .....

}

 

 

This causes qlik accordions to display poorly in the left menu. Is it a bug or an incompatibility with semantics?

Hi,

I have a variable like this:

v.excludeddate ='2024-01-01';'2024-09-01','2024-09-28','2024-10-05';

I need to count the distinct dates from this variable between the start of the current month and the end of the current month using a set expression. 

when i use count distinct I get 1.

Hi,
We have upgraded Qlik Sense and Nprinting version to the latest available. Would like to know whether there is any existing tool or a method to find the differences for before and after of different sections or categories like App, connections, etc.,

We see the number of count is higher post upgrade in almost all sections of QS and NPRINting. Manually doing the comparison is quite time consuming and thus asking the question.

Thanks.

I want to count the number of Parameters when calculating values ​​for each shift. The same value is repeated for 2 shifts.

This is the code used to calculate the values ​​for each shift.

if(Shift='Morning',Count({<Shift={'Morning'},LH_Name={"PD*"},AD_Remark-={"*ok*","*ปกติ*","*down*"},AD_ApproveStatus-={"1"}>}DISTINCT AD_Remark),
if(Shift='Afternoon',Count({<Shift={'Afternoon'},LH_Name={"PD*"},AD_Remark-={"*ok*","*ปกติ*","*down*"},AD_ApproveStatus-={"1"}>}DISTINCT AD_Remark),
if(Shift='Night',Count({<Shift={'Night'},LH_Name={"PD*"},AD_Remark-={"*ok*","*ปกติ*","*down*"},AD_ApproveStatus-={"1"}>}DISTINCT AD_Remark)) ))