Yesterday, I received community swag and would like to say thank you…

The recognition had already made me very happy, and receiving these items made it even more special. There is so much care and kindness in this gesture, and it truly means a lot.

Side note: Karppi and Scully,the biggest gossip girls in this house, loved them too! 😛

Thank you so much from the bottom of my heart.

Is it possible to graph only new customers by month using broad transactional data (fact table plus dimension tables), without using the load editor and using only set analysis? A new customer is one who bought for the first time in a given month and has never bought anything before.

Hello, I'm trying to create a line chart by week and average number of days. Using the `week` (field), I can get the weeks of the year (from 1 to 52), but I want to create a line chart that shows only the current month and its four weeks (1, 2, 3, 4, and 5).

I've tested some scripts, but none worked because they consider the average of the week numbers from previous years.

Does anyone have any idea how to solve this, either in the data loading script or in the chart itself?

Hi everyone,

I've been working on improving the structure and performance of my Qlik load scripts and front-end apps, and I want to make sure I'm following the most current best practices... not just what was recommended 3 or 4 years ago.

I'm looking for resources that cover topics like:

• Load script structure and organization
• Data model optimization (star schema, avoiding synthetic keys, QVD layers)
• Performance tuning (set analysis efficiency, AutoNumber, incremental loads)
• Naming conventions and maintainability

My question to the community: What are the most current and reliable sources you use to guide your development decisions? For example:

• Official Qlik help docs or whitepapers
• Community blogs or specific contributors you follow
• YouTube channels or webinars
• Internal standards your team has developed

Any links, authors, or resources you'd recommend would be greatly appreciated. Thanks in advance!

Apologies if this isn't the right part of the forum, I am happy to be directed to the appropriate place! I have reviewed a lot of the information around canonical dates here in the Community (Canonical Date - Qlik Community - 1463578, Let's Take a walk on the Calendar / Date Bridge: ... - Qlik Community - 2133428, Working with Multiple Calendars) and think I have a general sense of what I'm doing to make a canonical calendar but I'm running into a conceptual blocker that I would appreciate some help with.

In my dataset, customers apply for a course, have an assessment date, and a course start date if they are successful and then end dates each step. That's 6 dates in total - application receipt and process date, assessment start and completion date, and then course start and end date. During the course, there are regular reviews that are each associated with a single course record. Thus the course to review relationship is a one to many.

I am relatively confident in creating the canonical date for each of the start dates but two stumbling blocks I'm hitting are:

1. The start dates and end dates exist in the same table. When I add both into the canonical calendar, it creates a synthetic key as they share two columns. If my understanding of the canonical calendar is correct, I need to link each date that I want on the calendar. It is not sufficient to have just the start date connected to the calendar because it means that filtering by the canonical date will only include assessments, for example, that start on that date, not those that also end on that date. If so, I would appreciate guidance on preventing synthetic keys without reconfiguring the source data table.
2. One piece of guidance in the advice of developing a canonical calendar is to select the most granular record to develop your calendar around so you have a single date per record. The example given in my first link creates one table with all the dates. However, I would like to avoid doing this with my dataset as joining the reviews onto a application - assessment - course table would make it grow exponentially and duplicating a lot of data from a storage perspective with little gain in analysis terms. I can't see a reason why the canonical calendar won't work by just joining distinct tables to the directly to the date bridge rather than joining everything into one table but I am a novice, is there something I'm missing or can I just join my review dates directly to my date bridge?

Hopefully the above make sense but if any further information is required, please do shout! Appreciate any support anyone can provide.

Thanks in advance!

Hi,

I have implemented a solution for NPrinting on demand but when I published the app, the users are not able to generate the reports. When they login to NPrinting they are able to generate the reports. There are 50+ users for this app and I cannot tell everyone to login to NPrinting first and then generate the reports. Is there any setting I am missing?

Qlik NPrinting #Qlik

Background:
This is a multi-node Qlik Sense environment. There are total 6 nodes: Central node, Consumer Node 1, Consumer Node 2, Consumer Node 3, Consumer Node 3A, Scheduler Node.
There are load balancing rules for the consumption with stream based, where Central node is for Proxy use, Node 1 and 2 are only for consumption, Node 3 and 3A are for consumption and scheduler, Scheduler node is for scheduling. The consumption and scheduling are landing on the correct node.

Scenario of issue hit:
The client has implemented ODAG and encounter the issue, which the app generation is using random node instead of following the load balancing rule. Looking in Qlik Help portal, the reload will follow the rule set on the template app. 
They have the selection app in stream A (lb to Node 2), and template app in stream B (lb to Node3A). When they generate the app, the relevant ODAG service log is created in random node (eg. Node2). Furthermore, the log has indicated the app is open in random node (eg. Node 3.) By right it should follow the load balancing rule, to open and reload the app in Node 3A.

Looking forward for any advise as randomness of the reload will cause usage issue to the servers.

Best Regards,

Nelson

We are embedding a private Qlik Cloud sheet inside a React app and want backend-issued OAuth impersonation tokens so users are not redirected to Qlik login.

Tenant:
https://3sndgsisxteabed.in.qlikcloud.com

We created an OAuth Web client with M2M user impersonation.
Before publish, consent method shows trusted.
After publish, it changes to required.

Then backend POST /oauth/token with grant_type=urn:qlik:oauth:user-impersonation fails with:
oauth client is not approved with trusted consent method

Is trusted consent supported for published impersonation clients on Qlik Cloud?
Why does publish change it back to required?
Is there any supported no-redirect embed approach for this tenant if impersonation is blocked?

Hi,

I've been encountering an issue with importing apps for a while, and I'm trying to fix it.

The environment is Qlik Sense Enterprise, May 2025 version.
The issue is the following : when I try to import a QVF with the "Import" from the QMC, if the QVF is too big (only a few Mo), I get the error message : "Failed to import app. Please check the log file."
There is nothing of note in the logs, and if I import a QVF file of 160 Ko, there is no error.

The first curious thing is that the QVF file I try to import is a file I exported from another environement (typically, export from test to import in production), and I always make sure I export it without data, to be sure the file is not too big (5 632 Ko exactly for the file I used to test the import).

The second curious thing is that there is a workaround, with the choice of URL :
-I get the error if I try to import the QVF while connecting to the QMC from my desktop.
-If I try it locally, from the virtual machine where Qlik is installed, I also get the error if I use the same URL to connect to QMC than from my desktop.
-But, If I try it locally, this time connecting to the QMC with the localhost URL (https://localhost/qmc/), I can import the very same file (5 632 Mo) that created an error.

There is supposedly nothing wrong with the URL I use from my Desktop, since I can import the 160 Ko file.

So far, I didn't find anything explaining this difference of results depending on the URL.
Is there something I could try ?

Best regards.