Hi Guys,

I am trying to connect qliksense with the AWS RDS SQL DB the cloud team did their job of adding the security rules etc. I am able to communicate to the db from my QS dev server 10.209.192.30 via powershell(to test) with below script which also listed the tablenames but not able to create connection in qliksense.

it shows "Connection failed: please check the values of username, password, host and other properties. I was able to login to the DB on 10.209.64.140 with the same username and password. 

Powershell script: 

$server = "glonnopdbqax01.cnrdvfewbvrj.eu-west-1.rds.amazonaws.com,1431"

$user = "admin"

$pwd = "*****"

$dbName = "NetOpSandbox" # <--- Put the name from Step 1 here

# Updated Connection String with 'Database' parameter

$connString = "Server=$server;Database=$dbName;User ID=$user;Password=$pwd;Encrypt=True;TrustServerCertificate=True;"

$conn = New-Object System.Data.SqlClient.SqlConnection($connString)

try {

$conn.Open()

Write-Host "Successfully connected to database: $dbName" -ForegroundColor Green

# Example: List the first 5 tables in this database

$cmd = $conn.CreateCommand()

$cmd.CommandText = "SELECT TOP 5 TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'"

$tableReader = $cmd.ExecuteReader()

Write-Host "--- Tables Found ---" -ForegroundColor Cyan

while ($tableReader.Read()) {

Write-Host " > $($tableReader['TABLE_NAME'])"

}

$tableReader.Close()

$conn.Close()

}

catch {

Write-Error "Failed to connect to $dbName. Error: $($_.Exception.Message)"

}

//////////

I am using qliksense november 2024 patch 19 - 14.212.30 Not sure what exactly is the issue can please someone help me I am attaching the screenshots of connection and I also tried with all combination encrypt, trust server certificate etc still the same error. Is it the driver or patch issue. 

Any help will be highly appreciated.

Hi everyone,

I need help to solve the following problem.

Iframe don't work embedded in a PowerApp on the internal network, but they do work outside the internal network.

I don't know if the problem is with the network or the virtual proxy configuration.

The error is this: "The connection is blocked because it was initiated by a public page to connect to devices or servers on your local network"

Thanks,

Élio Godinho

Hi,

I need to count employees that move cost centre by month. I thought a flag in the script would allow me to do a set analysis for this purpose. In the below table, one employee (yellow highlight) has changed cost centres. I thought a concatenation of Cost Centre and EmployeeID and something like EXISTS or PEEK might do it, but I can't figure it out. Is this possible?

Many thanks

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 

Hey,

Was wondering if anyone has ran into the following issue. 

I am  trying to find Closest date to another date while having multiple entries.

I calculate days between and filter for min datebetween, but the issue is that i get multiple min days when grouping for final table. first sorted does not work because a single customer can have multiple events with same days between usually 0. And i cannot think of any key that would work 

looks something like this: 

TMP:
NoConcatenate
LOAD
*
where DAYS_BETWEEN >= 0 ;
load*,
if(isNULL(days_between_TEMP),0,days_between_TEMP) as DAYS_BETWEEN;
load *, EVENT_DATE - RISK_DATE as days_between_TEMP
RESIDENT QUACK;

FINAL:
LOAD CUSTOMER_ID,
SCORE,
EVENT_DATE,
MIN(DAYS_BETWEEN) as DAYS_TO_RISK
Resident TMP
group by CUSTOMER_ID,EVENT_DATE,RISK_DATE,SCORE;
DROP TABLEs QUACK, TMP;

Hello,

I've tried to activate kerberos in our QlikView-Environment. I used this documentation: https://community.qlik.com/t5/Official-Support-Articles/Kerberos-support-using-QlikView-Webserver/ta-p/1710991 

I changed the config.xml and "setspn" was executed. But if I try to open the AccessPoint I get "Login failed". I've used Edge und Firefox and both show the same error message.

Does anyone have an idea what could be wrong? Which log-files could be relevant (unfortunately I didn't find one that shows me more details)?

I know I ask where unspecific, but I didn't find a startingpoint yet for further investigation.

Our server are Windows 2016 and we're using QlikView May 2023SR1.

Kind regards

Peter

I am working on migrating QV to the QS project, which has this script. When I run same script with QlikView it works bt in Qs i get 0 value 

pls check and give the response at earlist 

In QlikView, we can easily create a table box and say "Add All" so that it adds all the fields to the table box in single shot.

Is something similar possible in Qlik Sense as well?

I end up adding each and every column individually now.

Cheers,

Naresh

Hi ,

I have question  to  calculate length or size  with type of column NCLOB /CLOB.  This column is document  pulled from  MOngo db and typical length function returns  0 or null. We tried to do it via global rule and direct operation on column in specific table. 

Thanks for any tips and  support. 

Regards