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: 
  • 264,187 members
  • 5,975 online
  • 2,045,627 posts
  • 154,238 Solutions
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!

Welcome to Qlik Community

Trending Forums

Recent Discussions

  • forum

    QlikView App Dev

    How to calculate number of years, months and days from number of days between 2 ...

    Hi,for example, this expression "=today() - date(date#('20200920','YYYYMMDD'))"returns 1879 as a result and I need to show number of years, months and... Show More

    Hi,

    for example, this expression "=today() - date(date#('20200920','YYYYMMDD'))"

    returns 1879 as a result and I need to show number of years, months and days between those 2 dates.

    Thanks

    Show Less
  • forum

    Management & Governance

    Visualistion Bundles missing

    After upgrading to the latest patch in December. The visualization bundles stopped working and displayed as invalid visualisations. Looking into the i... Show More

    After upgrading to the latest patch in December. The visualization bundles stopped working and displayed as invalid visualisations.

    Looking into the issue the had disappeared from the extension list.

    I have trie dthe following

    modifying / changing / repairing the bundle installation - no change.  am unable to remove as that option is greyed out.

    When I check the logs I am getting the following errors- 

    350 20250204T084038.700-0500 WARN System.Repository.Repository.Core.Resource.Support.ExtensionResourceSupport 50 d0117ad3-fb66-4122-8803-96f6472d5efa<username> Failed to add extension Exception of type 'System.Exception' was thrown.↵↓ZIP file error at Repository.Core.Util.ZipUtil.UnzipFile(String filePath, String destinationFolder, String password, Boolean deleteZipFile, String fileFilter)↵↓ at Repository.Core.Util.ZipUtil.UnzipFile(String filePath, String destinationFolder, String password, Boolean deleteZipFile, String fileFilter)↵↓ at Repository.Core.Resource.Support.ExtensionResourceSupport.Add(String path, String password, Boolean appendPrivileges, Boolean replaceExtension) c0de923a-c1c9-2f6b-db41-ae357858ccba d0117ad3-fb66-4122-8803-96f6472d5efa

    This is from the install log
    Error: POST /qrs/extension/upload?privileges=true&pwd=&xrfkey=4yAjqKO6JQCbPLow: 400

    Nothing else has changed other than he patch which was released as a security upgrade.

    Show Less
  • forum

    App Development

    Dynamic Fields in a Pivot Table + GetObjectField() function

    Hello, I am working with a pivot table in Qlik Sense with dynamic dimensions. The dimensionality is not fixed and might be affected by selections on t... Show More

    Hello,

     

    I am working with a pivot table in Qlik Sense with dynamic dimensions. The dimensionality is not fixed and might be affected by selections on two different data islands. I have to be careful as hidden dimensions impact this problem, as GetObjectField() can return a blank result ('') if the dimension's condition is not fulfilled.

     

    For my app, I need to compute percentages for each dimension by using the TOTAL qualifier with a different number of fields according to the dimensionality of the pivot table. The problem is users are allowed to change the order of the dimensions by moving the fields in the pivot table. For instance, they might put field2 before field1, and all other possible combinations.

    alexquimu_2-1762955199039.png

     

    Therefore, the order for the dimensions is really important as I compute the TOTAL according to the dimensionality of the table and the order of the fields. I use GetObjectField() along with variables to define the first dimension that is shown, vFirstDimension, defined as:

    if(len(GetObjectDimension(0)) > 0, 0,
        if(len(GetObjectDimension(1)) > 0, 1,
            if(len(GetObjectDimension(2)) > 0, 2,
            ''
            )
        )
    )

     Therefore, I can now use GetObjectField($(vFirstDimension)) to get the first dimension shown. For the second available dimension, I define vSecondDimension:

    if(len(GetObjectDimension($(vFirstUsedDimension)+1))>0,$(vFirstUsedDimension)+1,
    	if(len(GetObjectDimension($(vFirstUsedDimension)+2))>0,$(vFirstUsedDimension)+2,''))

    This does work, but as you can imagine, there are plenty of nested if statements, and the final app is getting slow because of this.

     

    Note: dimensions are shown according to the selections made on a data island; however, I can't simply concat the field as it won't respect the order when moving the field order in the pivot table itself.

     

    Do you have any suggestions for resolving this performance problem?

    Thanks in advance.

     

    Greetings,
    Alex

     

    Show Less
  • forum

    Management & Governance

    Overage notification

    Hi everyone, in Qlik Cloud capacity-based model, the service account owner is notified via email approaching a capacity limit (at 90%, 95%, and 100% o... Show More

    Hi everyone, in Qlik Cloud capacity-based model, the service account owner is notified via email approaching a capacity limit (at 90%, 95%, and 100% of the limit). Is it possible to automatically send the same email to other recipients? Additionally, is it possible to customize the alert thresholds?

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Insert issue in the Databricks Delta lakehouse Delta on GCP.

    hi all, I have Source as oracle and target as Databricks Delta tables on GCP. Here Qlik not support for the Cloud native function as Data enrichment f... Show More

    hi all,

    I have Source as oracle and target as Databricks Delta tables on GCP. Here Qlik not support for the Cloud native function as Data enrichment function in the 2024 and 2025 Version.

    So i added one column manual at the target DBRX end as Current_timestamp.

    ALTER TABLE vvv ADD COLUMN audit_created_datetime TIMESTAMP;
    ALTER TABLE vvv SET TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported');
    ALTER TABLE vvv alter column audit_created_datetime set default current_timestamp();

    But here when i get full load using Qlik replicate i need Current timestamp and when ever i got INSERT i need the col audit_Created_Datetime as current_timestamp values.

    Even i add as Replace column value as audit_Created_datetime as datetime('now', 'UTC'). i got NULL in the column kindly give the solution.

     

    Show Less
  • forum

    Connectivity & Data Prep

    Data Gateway Direct Access Error - Dynamic port binding is not supported when bi...

      Hello Comunnity, I followed all the installation instructions from the official documentation for Qlik Data Gateway – Direct Access.The installation... Show More

     

    Hello Comunnity,

    I followed all the installation instructions from the official documentation for Qlik Data Gateway – Direct Access.
    The installation process completes successfully, but when running the following command to configure the tenant:


    connectoragent qsc set_config --tenant_url XXXXXXXX.us.qlikcloud.com

     

    the service fails to start and returns the following error message:

    Dynamic port binding is not supported when binding to localhost. You must either bind to 127.0.0.1:0 or [::1]:0, or both.

     

    I have tested this using a cleam SO Windows Server 2025, 2022, and 2019, (AWS Ec2 instances) and the issue occurs in all of them.

    The environment includes the following .NET runtimes, which are installed automatically with the latest Qlik Data Gateway (Direct Access) installer:

     

     
    Microsoft.AspNetCore.App 8.0.21 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App] Microsoft.NETCore.App 8.0.21 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]

    Could you please confirm if this is a known issue or if any specific .NET version or configuration is required to support Kestrel on these Windows versions?

    Thank you for your help.

    Best regards,



    This is the full error message:

    C:\Program Files\Qlik\ConnectorAgent\ConnectorAgent>connectoragent qsc set_config --tenant_url XXXXXXX.us.qlikcloud.com
    connector-agent starting as standard .net core process....
    {"TimeStamp":"12-11-2025 13:32:21.729","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"environment-info: GatewayVersion=1.7.8, AgentVersion=1.31.2, ProcessorCount=2, WorkingSet=35 MB, OS=Microsoft Windows NT 10.0.17763.0, TimeZoneOffset=00:00 (0.0)","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:21.903","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Using default port from config 0","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:21.903","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Setting CONNECTOR_AGENT_PORT for non-default port","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:24.312","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Log options enabled: 'NONE'","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:24.317","ProcessId":"3128","Thread":"1","Level":"WARN","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"If AGENT_LOG_OPTIONS are configured, then at least one logging option must be enabled. All non-verbose logging options at the current AGENT_LOG_LEVEL will be enabled.","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:24.318","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Trace: RelayCommand enabled and will be output to DirectAccessAgent.log","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:24.319","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"QVX","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"Chunks ack capability is not supported","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:24.71","ProcessId":"3128","Thread":"1","Level":"INFO","PipeName":null,"Source":"DAG","ReloadId":"NA","TenantId":"NA","UserIdType":"NA","UserId":"NA","EngineSessionId":"NA","AppId":"NA","RequestGuid":"NA","Message":"AsyncLoadDataRequest is disabled. Connector startup timeout set to 30 seconds per attempt with 3 max attempts","Exception":null}
    {"TimeStamp":"12-11-2025 13:32:26.935","ProcessId":"3128","Thread":"1","Level":"ERROR","Message":"System.InvalidOperationException: Dynamic port binding is not supported when binding to localhost. You must either bind to 127.0.0.1:0 or [::1]:0, or both.\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.LocalhostListenOptions..ctor(Int32 port)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.ParseAddress(String address, Boolean& https)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.AddressesStrategy.BindAsync(AddressBindContext context, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.AddressBinder.BindAsync(ListenOptions[] listenOptions, AddressBindContext context, Func`2 useHttps, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.BindAsync(CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.StartAsync[TContext](IHttpApplication`1 application, CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Hosting.WebHost.StartAsync(CancellationToken cancellationToken)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String startupMessage)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String startupMessage)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token)\r\n at Microsoft.AspNetCore.Hosting.WebHostExtensions.Run(IWebHost host)\r\n at Qlik.ConnectorAgent.AgentProcessBase.StartAgent(String[] args, Boolean isService)","Exception":null}

    Show Less
  • forum

    Management & Governance

    Qlik Cloud - Forcing MFA for Native Authentication Users

    Hello everyone,regarding access to Qlik Cloud, when using native authentication, can we force the use of MFA for all users (at least for users of a te... Show More

    Hello everyone,

    regarding access to Qlik Cloud, when using native authentication, can we force the use of MFA for all users (at least for users of a tenant)?

    Thanks

    Show Less
  • forum

    App Development

    Parametrized variable not working

    Good morning all, I was looking for some help with this problem I am having with a parametrized variable.  In the editor I define the following variab... Show More

    Good morning all,

    I was looking for some help with this problem I am having with a parametrized variable. 

    In the editor I define the following variables:

    Set vFormatBigNum = Dual(Num($1/ Pow(10, 3 * Div(Log10(fabs($1)),3)),'#.##0,0') & '' & Pick(Div(Log10(fabs($1)), 3),'k','M','B','T'), $1);
    SET vNumFormatKPI = if($1 = 'BIGMONEY', '€' & $(vFormatBigNum($2))
              , if($1 = 'MONEY', '€' & num($2, '#.##0,0')
                , if($1 = 'BIGINTEGER', $(vFormatBigNum($2))
                            , if($1 = 'INTEGER', num($2, '#.##0')
                                  , if($1 = 'DECIMAL', num($2, '#.##0,0')
                                      , if($1 = 'PERCENTAGE', num($2, '#.##0,00%')
                                          , $2))))));

     

    Which I than use in the sheet for a KPI value:

    if(YEAR_TO_DATE_CALC = 'SUM'
    , $(vNumFormatKPI(VALUE_TYPE, sum(ACTUAL_VALUE)))
        , $(vNumFormatKPI(VALUE_TYPE, avg(ACTUAL_VALUE))))
     
    This worked correctly; However one of the variables I have sometimes has negative values which I do not want to include in the average. So I rewrote the equation to:

     

    if(YEAR_TO_DATE_CALC = 'SUM'
    , $(vNumFormatKPI(VALUE_TYPE, sum(ACTUAL_VALUE)))
        , $(vNumFormatKPI(VALUE_TYPE, avg(if(KPI = '%Bonus to GGR', if(ACTUAL_VALUE > 0, ACTUAL_VALUE), ACTUAL_VALUE)))))
     
    And now Qlik throws an error, and when you look at the error message most of the question within the average seems to be ignored (see the highlighted part):
     
    NLO_CM_0-1762766536507.png

     

    How I solve this issue?

    Show Less
  • forum

    Visualization and Usability

    Line-Chart rendering showing zeros for truncated data

    Not sure if this is a feature or a bug -  but if a line chart is painted with its point/line count limited, where points are pruned from a chart, they... Show More

    Not sure if this is a feature or a bug -  but if a line chart is painted with its point/line count limited, where points are pruned from a chart, they're displayed as zeros .

    For example I'm rendering a historical FX rate chart  - at first I had a heart attack as I thought we were missing data.


    Screenshot 2025-11-12 135048.png


    When I zoom in with the scroll wheel, they eventually paint up.
    Screenshot 2025-11-12 140628.pngScreenshot 2025-11-12 140634.png

    Ideally, even though the points may be being pruned, I'd expect the behaviour to be similar to below, where gaps were connected ( as set in 'Missing Values >  Show as connections ) 

    Screenshot 2025-11-12 135057.png

     

     

     

    If I can get my access to the Pendo.Io  login for the Ideation I'll post it there.

    Show Less
  • forum

    Visualization and Usability

    Email Alerts for reload tasks failure in QlikSense

    Hi Team,I am planning to set up Email alerts for reload failures in Qliksense QMC. I have gone through some discussion over community and found that h... Show More

    Hi Team,

    I am planning to set up Email alerts for reload failures in Qliksense QMC. I have gone through some discussion over community and found that https://github.com/NickAkincilar/QlikSense-Task-Failure-Email-Alerts

    Can any one help me with setting up this in my Qliksense server(Mine is Single node server)??

    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

Catalyst Cloud (Fusion)

Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.

Customer Story

Catalyst Cloud (Coeus SEP)

Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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.