Hi,

We have QlikSense Enterprise on Windows version May 2025, the PostgreSQL bundle is version 14.

By security policy we need to move the version of PostgreSQL to version 17.

Somebody knows a procedure to do that?

Kind regards,

Gabriel.

As above, recently started in a new environment and been reviewing the DEV/TEST environment as its PostgreSQL host keeps on running into disk space issues.

After reviewing the PostgreSQL install I identified the QLogs DB consuming over 15GB of space and growing.

I can see entry timestamps from today so it's still getting written to.

My previous environment did not use Centralized logging at all so a bit unfamiliar of this however my understanding is QLogs/Central Logging was depreciated in 2021, and more importantly the Service/Executable does not exist in current versions.

So how is QLogs getting updated in this environment?

Is it safe to Drop the QLogs DB in this instance? 

If not safe to Drop, what is the correct method to removing Centralized Logging from this environment? Considering we have no use for QLogs anymore.

Thanks

Currently I use  a shared login for a dept. Would like to have separate accounts now and then have those users see the shared sheets but not the whole app community.

Is this possible?

Hi everyone,

I'm trying to set up an OIDC connection between Qlik Cloud and Azure AD, but I'm encountering the following error during the validation step:

{ "status": "error", "protocol": "OIDC", "error": "Failed to decrypt ID token", "traceId": "<hidden>" }
Setup details:

Protocol: OIDC
Identity Provider: Azure AD
Redirect URI: https://<tenant>.<region>.qlikcloud.com/login/callback
(this URI is configured both in Azure and in Qlik)

What I've tried so far:

ID token issuance is enabled (enableIdTokenIssuance: true)

Implicit grant flow is enabled

Optional claims are configured: upn, email, groups

A client secret is registered

The app is registered as AzureADMyOrg

I'm not intending to encrypt the ID token, and have not configured any tokenEncryptionKeyId.

Still receiving the "Failed to decrypt ID token" error.

Try to understand :

Why would Qlik try to decrypt the token if no encryption was configured

Could this be caused by missing or misconfigured claims

Has anyone else encountered this ?

Thanks in advance for any suggestions or insights

Eyal

@Benoit_C 

Hi,
We use Fiplana extensions (Write, Edit, etc.) from insightsoftware in Qlik Cloud.

As of today, we are receiving the following error message for all Fiplana visualizations: “Invalid visualization. The visualization failed to load. The extension was not found or caused an error: QS Edit.”

The licenses are still valid, and the latest release has been installed.

Does anyone know what the problem is?

Best regards,
Thomas

The new QSDA Pro 3.5 just dropped, and it gives us the surgical tools to audit the "vitals" of our ecosystem.

1. The App Analysis Score. 

A benchmark designed to quantify the quality and health of a Qlik application - it aggregates unused data model weight, error flags, and governance metrics into a single metric. It’s the ultimate way to benchmark your production readiness.

2. Expression Complexity Score.
A composite of several factors: Function Count, Function Nesting Depth, Advanced Function Count and others. It's perfect tool to point at a measure and say: "This isn't just logic; it’s a maintenance liability." If the score is high, you're looking at a performance tax you’ll eventually have to pay - either in CPU cycles or in the hours spent trying to fix it later.

3. Script Reload Log Analysis.
Insights into reload bottlenecks are now baked directly into the collection process. Reload Log Analyzer parses Qlik Sense reload logs to provide a line-level breakdown of script execution time. It transforms flat log files into a visual timeline, allowing developers to pinpoint exact performance bottlenecks within the load script.

Learn more in QSDA Pro Docs - https://help.easyqlik.com/qsdav35/topics/idh-topic1610.htm
Looking for feedback!

#QSDAPro #QlikSense #QlikCloud #QlikAppHealth 

The new QSDA Pro 3.5 just dropped, and it gives us the surgical tools to audit the "vitals" of our ecosystem.

1. The App Analysis Score. 

A benchmark designed to quantify the quality and health of a Qlik application - it aggregates unused data model weight, error flags, and governance metrics into a single metric. It’s the ultimate way to benchmark your production readiness.

2. Expression Complexity Score.
A composite of several factors: Function Count, Function Nesting Depth, Advanced Function Count and others. It's perfect tool to point at a measure and say: "This isn't just logic; it’s a maintenance liability." If the score is high, you're looking at a performance tax you’ll eventually have to pay - either in CPU cycles or in the hours spent trying to fix it later.

3. Script Reload Log Analysis.
Insights into reload bottlenecks are now baked directly into the collection process. Reload Log Analyzer parses Qlik Sense reload logs to provide a line-level breakdown of script execution time. It transforms flat log files into a visual timeline, allowing developers to pinpoint exact performance bottlenecks within the load script.

Learn more in QSDA Pro Docs - https://help.easyqlik.com/qsdav35/topics/idh-topic1610.htm
Looking for feedback!

#QSDAPro #QlikSense #QlikCloud #QlikAppHealth 

Hi all, 

I am very new to Qlik and still learning Qlik expressions and Set Analysis. I am stuck on a seemingly a very simple task and it appears that ChatGPT has also given up and I cannot find any answers anywhere that can help me with this issue. 

So my requirements are pretty simple: A Straight table with the following columns: 

Column 1:   [MMM YYYY]  = Date formatted as [MMM YYYY]

Column 2:   [Sales]             = Sales for each [MMM YYYY] for the select period 

Column 3:   [Sale LY]          = Sales from the Previous Year, Same month as [MMM YYYY]

In Power BI it will take me less than 2 minutes to do this, by just simply using SAMEPERIODLASTYEAR() function. But Qlik is having none of it and I have tried almost 50 different solutions trying to achieve this. 

So I have a FactSales table and a MasterDateCalendar table. 

My Sales Expression looks pretty simple: 

=Sum([SalesAmount])

For Sales LY I have tried a number of things: 

=Sum(
  {$<
    [SalesDate] =,
    Month =,
    Year =,
    MMYYYY =,
    MMMYear =,
    YYYYMM =,
    YYYYMM = {"=$(=Only(YYYYMM)-100)"}>}
  [SalesAmount]
)

Another thing I have tried: 

=Sum(
  {$<
    [SalesDate] =,
    Month =,
    Year =,
    MMYYYY =,
    MMMYear =,
    YYYYMM =,
     [SalesDate] = {">=$(=Num(AddYears(Only([FirstDateofMonth]), -1)))<=$(=Num(AddYears(Only([LastDateofMonth]),  -1)))"}>}
  [SalesAmount]
)

[FirstDateofMonth] and [LastDateofMonth] are columns from my MasterDateCalendar table. 

All of the above show Zeros for Sales LY. 

I am absolutely gobsmacked by the fact that such a simple thing in a BI tool could be this difficult to achieve. 

Ideally, I would want a straight table with output as shown in the attached image. 

Any help or pointers in the right direction will be much appreciated. 

Thanks in advance.