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,028 members
  • 4,681 online
  • 2,045,461 posts
  • 154,229 Solutions
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Welcome to Qlik Community

Trending Forums

Recent Discussions

  • forum

    Talend Studio

    tRest - resume next

    I have a loop that pulls a list of ids and executes a tRest api for each id.  This works until it doesn't.When it works it brings back json with it's ... Show More

    I have a loop that pulls a list of ids and executes a tRest api for each id.  This works until it doesn't.

    When it works it brings back json with it's Body and ERROR_CODE columns.  From there I can troubleshoot any data.  But occasionally it brings back a random xml that I can't even capture.  It fails the trest component with a error...

    "Too many "Content-Type" header values: "[text/xml: charset="utf-8", null]"

    Is there a way that when the api blows up, I can do a resume next or any continue to the next iteration?

     

    Show Less
  • forum

    Data Quality

    QS | Text value of dates is not getting link to dual field of date

    Hi,I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well... Show More

    Hi,

    I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well.

    Dual(Date1,-1*Date1)  giving result 2025/10

    While i tried to incorporate this changes into my existing dates i.e Date which is also holding dates in 2025/10 format but in Text format its not working.

    Let say i wanted to show YTD and Rolling 12 months data when clicking on action button.Its wokring fine and getting associated and selecting with green color.

    R12 Logic:

    =year(addmonths(TODAY(),-2))&'/'&if(num(month(addmonths(TODAY(),-2)))<10,'0','')&num(month(addmonths(TODAY(),-2)))&';' &year(addmonths(TODAY(),-3))&'/'&if(num(month(addmonths(TODAY(),-3)))<10,'0','')&num(month(addmonths(TODAY(),-3)))&';' &year(addmonths(TODAY(),-4))&'/'&if(num(month(addmonths(TODAY(),-4)))<10,'0','')&num(month(addmonths(TODAY(),-4)))&';' &year(addmonths(TODAY(),-5))&'/'&if(num(month(addmonths(TODAY(),-5)))<10,'0','')&num(month(addmonths(TODAY(),-5)))&';' &year(addmonths(TODAY(),-6))&'/'&if(num(month(addmonths(TODAY(),-6)))<10,'0','')&num(month(addmonths(TODAY(),-6)))&';' &year(addmonths(TODAY(),-7))&'/'&if(num(month(addmonths(TODAY(),-7)))<10,'0','')&num(month(addmonths(TODAY(),-7)))&';' &year(addmonths(TODAY(),-8))&'/'&if(num(month(addmonths(TODAY(),-8)))<10,'0','')&num(month(addmonths(TODAY(),-8)))&';' &year(addmonths(TODAY(),-9))&'/'&if(num(month(addmonths(TODAY(),-9)))<10,'0','')&num(month(addmonths(TODAY(),-9)))&';' &year(addmonths(TODAY(),-10))&'/'&if(num(month(addmonths(TODAY(),-10)))<10,'0','')&num(month(addmonths(TODAY(),-10)))&';' &year(addmonths(TODAY(),-11))&'/'&if(num(month(addmonths(TODAY(),-11)))<10,'0','')&num(month(addmonths(TODAY(),-11)))&';' &year(addmonths(TODAY(),-12))&'/'&if(num(month(addmonths(TODAY(),-12)))<10,'0','')&num(month(addmonths(TODAY(),-12)))&';' &year(addmonths(TODAY(),-13))&'/'&if(num(month(addmonths(TODAY(),-13)))<10,'0','')&num(month(addmonths(TODAY(),-13)))

    E.g 2025/10;2025/09;2025/08;...2024/11

    The problem statement is when clicking on R12 button my new Date1 which got created using Dual is not getting selected with green color although its getting associated as per Qlik associative nature.

    I tried many approache to get this link but no luck.

    Karim_Khan_0-1762429489716.png

    Karim_Khan_1-1762429517246.png

     

    Show Less
  • forum

    Qlik Replicate

    Enabling Task policy instead of global policy in Apply changes for Stored change...

    HI Team,Currently Qlik replicate child task is enabled with Stored changes only for CDC processing.We are keeping global policy from Apply conflicts a... Show More

    HI Team,
    Currently Qlik replicate child task is enabled with Stored changes only for CDC processing.
    We are keeping global policy from Apply conflicts and using Upsert mode(for duplicates and inserts not found).Can we change this to Task policy for Stored changes.
    Incase Global handling policy is needed, then still do we need upsert mode to be existed.
    Will it cause delay(latency) while writing entries to attrep_changes table in Databricks.

    Currently we are seeing latency while writing cdc data through Insert/SQL merge queries from Qlik->to s3->Databricks.
    From error handling perspective between qlik-> databricks delta, Please let us know the recommendation for Apply Conflicts in this case.

    Source:MS Sql server(MS-CDC)

    Target:Databricks Delta

     

    Thanks,

    Sudarsan K

    Show Less
  • forum

    Reporting Service & Alerting

    SMTP Email provider error

    I am setting up an SMTP Email Provider in a Qlik Cloud Academic account. The SMTP provider is Outlook.com and it uses TLS encryption. However, Qlik Ad... Show More

    I am setting up an SMTP Email Provider in a Qlik Cloud Academic account. The SMTP provider is Outlook.com and it uses TLS encryption. However, Qlik Administration Settings gives an error when I Save if Security is set to StartTLS or SSL/TLS:

    Email provider is not working as expected:

    * Unable to verify provider configuration.

    If I change Security to None then Save works. But clicking Test E-mail returns an error after a few seconds:

    There was a problem sending your email. Please review your settings.

    I have verified the SMTP settings with Outlook.com as well as the email username and password. Is there any known issue using Outlook.com?

     

     

    Show Less
  • forum

    Visualization and Usability

    Error after deleting Bookmark

    Hi all,I encounter a rather strange error : on an app, I used to have a default bookmark, to make sure that all users would land on a specific sheet, ... Show More

    Hi all,

    I encounter a rather strange error : on an app, I used to have a default bookmark, to make sure that all users would land on a specific sheet, with a value already selected on a slicer.

    Since this was no longer useful, I recently deleted the bookmark.

    Since then, when someone opens the app, there is an error message : "The bookmark you are trying to reach is unavailable. No selection was applied".

    I checked various things, but the bookmark is of course deleted in the app, there is nothing wrong in the app objects, and also tried to select other values in the slicer before closing the app, but nothing works, I still get the message every time I open the app.

    Is there something I'm missing ?

    Best regards.

    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

    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

    Qlik Automate

    [QLIK AUTOMATION] : using get tabular report not able to assign the name to exce...

    Hi,I am using qlik automation to generate excel and sending in mail, It is generating random numbers, I want to provide the name, I have already given... Show More

    Hi,

    I am using qlik automation to generate excel and sending in mail, It is generating random numbers, I want to provide the name, I have already given name to template file but still it is generating file like below

    Fenil_0-1758896287584.png

    Fenil_1-1758896298690.png


    Please let me know How I can provide the name.

    Thanks,
    Fenil Jain

     

    Show Less
  • forum

    Mobile

    Third-party extensions in offline mode for Qlik Cloud mobile

    Hello Qlik Community,Can anyone share an official statement or clarification regarding the behavior and support status of third-party visualization ex... Show More

    Hello Qlik Community,

    Can anyone share an official statement or clarification regarding the behavior and support status of third-party visualization extensions when consuming apps offline in Qlik Cloud mobile?

    Here’s what I’ve observed:

    • The same app and extensions (for example, PowerKPI, qsSimpleList) work correctly online in Qlik Cloud mobile.

    • But when I download the app for offline use and open it in offline mode, the extension visualizations fail to render with the error:
      “Invalid visualization / The extension is not available.”

    • The same app and extensions render correctly when downloaded and opened offline in the Qlik Sense Enterprise on Windows (Client-Managed) mobile app.

    According to Qlik Cloud Help, “third-party visualization extensions may behave differently in the Qlik Analytics mobile app” and it recommends using native Qlik visualizations. However, it does not explicitly clarify whether third-party extensions are expected to work offline, or if this behavior is a known limitation.

    also here https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Mobile-for-SaaS-FAQ/ta-p/1805641

    Do Qlik Sense Extensions / Themes work on QSM?
    Qlik Sense Extensions and Themes are supported both when apps are online and offline. Some specific extensions may be inherently online if internally they are calling out to different servers/services.

    Can someone from Qlik confirm what the expected behavior is in Qlik Cloud mobile offline mode?

    • Are third-party extensions supported offline?

    • If not, is there any official KB or roadmap item describing this limitation?

    Thank you!

    Show Less
  • forum

    Qlik NPrinting

    Qlik Nprinting Vertical Band Not avaliable

    Hi ,I am Currently using Nprinting desktop designer (24.4.10.0), in which vertical band is not available.Please refer the attached image for reference... Show More

    Hi ,

    I am Currently using Nprinting desktop designer (24.4.10.0), in which vertical band is not available.

    Please refer the attached image for reference.

    Kindly help me to identify this issue.

     

     

    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.