Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 268,256 members
  • 8,399 online
  • 2,043,501 posts
  • 154,427 Solutions
Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!

Welcome to Qlik Community

Recent Discussions

  • forum

    Visualization and Usability

    Qliksense Microsoft sql server connectivity issue

    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 communic... Show More

    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.

     

     

    Show Less
  • forum

    App Development

    Embedded links in iframes within a Power App are not working on the internal net...

    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 ... Show More

    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

    Show Less
  • forum

    App Development

    Create flag against employees that change cost centre by month

    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 t... Show More

    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?

    CC change.png

    Many thanks

    Show Less
  • forum

    Visualization and Usability

    Background music to a Qlik Sense story

    Hi All,Is it possible to add some back ground music to a Qlik Sense story?
  • forum

    Integration, Extension & APIs

    OIDC Setup – "Failed to decrypt ID token" Error with Azure AD

    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 st... Show More

    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 

    Show Less
  • forum

    App Development

    Selecting minimum value with multiple conditions

    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 cal... Show More

    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;

    Show Less
  • forum

    QlikView Administration

    Problem with kerberos authentication

    Hello, I've tried to activate kerberos in our QlikView-Environment. I used this documentation: https://community.qlik.com/t5/Official-Support-Articles... Show More

    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

    Show Less
  • forum

    Connectivity & Data Prep

    Exists() function doesn't work in QS with applymap pls check

    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... Show More

    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 

    mapping:
    Mapping
    Load * Inline [
    Period_PERIO, Month
    001, 4
    002, 5
    003, 6
    004, 7
    005, 8
    006, 9
    007, 10
    008, 11
    009, 12
    010, 1
    011, 2
    012, 3
    ];
     
    COEP:
    LOAD [GL Code] as [Cost Element],
    TYPE,
    [Group Under],
    [GL Name]
     
    FROM
    [lib://Qliksense Qvds (kelkargroup_qlikadm)/GL LIST FOR OPEX BUDG 19-20.xlsx]
    //[..\Qvds\GL LIST FOR OPEX BUDG 19-20.xlsx]
    (ooxml, embedded labels, table is [GL LIST]);
     
     
     
    left join(COEP)
    LOAD ApplyMap('mapping',Period_PERIO) AS MONTH1,
    [Company Code_BUKRS]&'-'& Right([Object number_OBJNR],10) as %KEY_COEP_CSKS,
    [CO Area_KOKRS] as [Controlling Area], 
         [Object number_OBJNR],
    //      [Cost Element],
          [Cost Element_KSTAR],
         Right([Object number_OBJNR],10) as [Cost Center Code],
         [Fiscal Year_GJAHR] as [Fiscal Year], 
    [Company Code_BUKRS] as [Company Code],
         [Cost Element_KSTAR] as [Cost Element], 
         [Value TranCurr_WTGBTR] as [Value TranCurr], 
         [Value/Obj. Crcy_WOGBTR] as [Value/Obj. Crcy], 
         [Val/COArea Crcy_WKGBTR] as [Val/COArea Crcy], 
         [Trans. Currency_TWAER] as [Trans. Currency], 
         [Object Currency_OWAER] as [Object Currency], 
         [Posting row_BUZEI],
         Period_PERIO ,   
         [Document Number_BELNR] as [Contrilling Document Number],
         Name_SGTXT as Name,
          Right(AuxAcctAsmnt_1_OBJNR_N1,8) as [Employee Code],
         [Purchasing Doc._EBELN] as Purchase_NO,
         if(wildmatch(Period_PERIO,'010','011','012'),MakeDate([Fiscal Year_GJAHR]+1, ApplyMap('mapping',Period_PERIO),1),MakeDate([Fiscal Year_GJAHR], ApplyMap('mapping',Period_PERIO),1)) as Period,
         month(if(wildmatch(Period_PERIO,'010','011','012'),MakeDate([Fiscal Year_GJAHR]+1, ApplyMap('mapping',Period_PERIO),1),MakeDate([Fiscal Year_GJAHR], ApplyMap('mapping',Period_PERIO),1))) as MONTH
    FROM
    [lib://Qliksense Qvds (kelkargroup_qlikadm)/COEP.QVD]
    (qvd) Where WildMatch([Object number_OBJNR],'KS*') and [Fiscal Year_GJAHR]>= Year(Today())-2 
    and Exists([Cost Element],[Cost Element_KSTAR])
    ;
    Show Less
  • forum

    Visualization and Usability

    How to add all the columns into Qlik Sense chart(table)?

    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 po... Show More

    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

    Show Less
  • forum

    Qlik Replicate

    Problem with calculate size/length on column.

    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 lengt... Show More

    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

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Enhancing Customer Experience Through Smarter Insights

By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.

Customer Story

Breaking Down the Data Bottlenecks

Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.